PREVIEW / etf_1hour / 2022-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-10.parquet
  size:    455 KB
  rows:    16,494

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2022-08-10 04:00:00	SPY	ETF	411.65	412.75	411.49	412.62	14978.0
2022-08-10 05:00:00	SPY	ETF	412.54	412.81	412.26	412.38	10255.0
2022-08-10 06:00:00	SPY	ETF	412.36	412.44	412.02	412.21	20371.0
2022-08-10 07:00:00	SPY	ETF	412.21	412.72	412.12	412.7	100408.0
2022-08-10 08:00:00	SPY	ETF	412.19	419.0	410.95	418.09	3399111.0
2022-08-10 09:00:00	SPY	ETF	418.08	418.88	417.205	418.2	8225916.0
2022-08-10 10:00:00	SPY	ETF	418.21	418.84	416.72	418.77	6989378.0
2022-08-10 11:00:00	SPY	ETF	418.77	420.04	418.77	419.59	6497974.0
2022-08-10 12:00:00	SPY	ETF	419.59	419.79	418.33	419.0607	3896507.0
2022-08-10 13:00:00	SPY	ETF	419.065	419.81	418.7	419.4299	4211103.0
2022-08-10 14:00:00	SPY	ETF	419.43	419.625	418.46	418.4901	3929448.0
2022-08-10 15:00:00	SPY	ETF	418.4916	420.14	418.35	419.95	11114969.0
2022-08-10 16:00:00	SPY	ETF	419.94	420.17	418.9	419.95	3687746.0
2022-08-10 17:00:00	SPY	ETF	419.99	420.0	419.8	419.94	142186.0
2022-08-10 18:00:00	SPY	ETF	419.92	419.92	419.59	419.66	39292.0
2022-08-10 19:00:00	SPY	ETF	419.62	420.2	419.27	420.08	102691.0
2022-08-10 04:00:00	QQQ	ETF	316.95	318.55	316.9	318.4	74539.0
2022-08-10 05:00:00	QQQ	ETF	318.46	318.76	317.96	318.07	32967.0
2022-08-10 06:00:00	QQQ	ETF	317.91	318.04	317.48	317.74	107150.0
2022-08-10 07:00:00	QQQ	ETF	317.74	318.42	317.55	318.39	141495.0
2022-08-10 08:00:00	QQQ	ETF	317.61	325.38	316.11	324.26	3895006.0
2022-08-10 09:00:00	QQQ	ETF	324.3	325.05	322.81	323.99	8792668.0
2022-08-10 10:00:00	QQQ	ETF	324.01	324.56	322.0601	324.31	6097803.0
2022-08-10 11:00:00	QQQ	ETF	324.34	325.59	324.34	325.47	4706880.0
2022-08-10 12:00:00	QQQ	ETF	325.46	325.71	323.97	324.5718	2893748.0
2022-08-10 13:00:00	QQQ	ETF	324.595	325.78	324.055	325.295	2906162.0
2022-08-10 14:00:00	QQQ	ETF	325.31	325.54	324.5	324.55	2505062.0
2022-08-10 15:00:00	QQQ	ETF	324.53	326.23	324.3801	325.92	6425008.0
2022-08-10 16:00:00	QQQ	ETF	325.87	325.95	316.64	325.55	2939041.0
2022-08-10 17:00:00	QQQ	ETF	325.72	325.72	325.46	325.7	50157.0
2022-08-10 18:00:00	QQQ	ETF	325.66	325.66	325.35	325.4896	59784.0
2022-08-10 19:00:00	QQQ	ETF	325.48	326.09	325.47	326.01	72119.0
2022-08-10 04:00:00	IWM	ETF	190.19	190.85	190.19	190.73	22006.0
2022-08-10 05:00:00	IWM	ETF	190.7	190.73	190.51	190.61	4202.0
2022-08-10 06:00:00	IWM	ETF	190.5	190.66	190.34	190.41	5869.0
2022-08-10 07:00:00	IWM	ETF	190.45	190.64	190.4	190.58	41360.0
2022-08-10 08:00:00	IWM	ETF	190.4	193.99	190.4	193.55	683836.0
2022-08-10 09:00:00	IWM	ETF	193.53	194.68	193.11	194.0	3040348.0
2022-08-10 10:00:00	IWM	ETF	194.0	194.92	193.27	194.845	2593814.0
2022-08-10 11:00:00	IWM	ETF	194.86	195.23	194.62	194.92	1979909.0
2022-08-10 12:00:00	IWM	ETF	194.92	195.06	194.46	195.0	724134.0
2022-08-10 13:00:00	IWM	ETF	195.01	195.55	194.87	195.39	1673370.0
2022-08-10 14:00:00	IWM	ETF	195.4	195.53	195.17	195.224	1410146.0
2022-08-10 15:00:00	IWM	ETF	195.22	195.95	195.13	195.65	2886091.0
2022-08-10 16:00:00	IWM	ETF	195.62	195.8	195.51	195.55	1265376.0
2022-08-10 17:00:00	IWM	ETF	195.42	195.79	195.42	195.68	52654.0
2022-08-10 18:00:00	IWM	ETF	195.66	195.66	195.45	195.55	23849.0
2022-08-10 19:00:00	IWM	ETF	195.56	195.85	195.49	195.73	27917.0
2022-08-10 04:00:00	DIA	ETF	328.54	328.76	328.54	328.76	500.0
2022-08-10 06:00:00	DIA	ETF	328.53	328.53	328.53	328.53	452.0

> showing 50 of 16,494 rows — these rows as CSV

> unlock the full archive -- $79 one-time