PREVIEW / etf_1hour / 2021-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-08.parquet
  size:    436 KB
  rows:    15,473

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
2021-03-08 04:00:00	SPY	ETF	381.26	381.45	379.42	380.55	109711.0
2021-03-08 05:00:00	SPY	ETF	380.8	381.49	380.48	381.32	208982.0
2021-03-08 06:00:00	SPY	ETF	381.32	381.85	381.07	381.8	145873.0
2021-03-08 07:00:00	SPY	ETF	381.89	382.25	380.83	381.34	623403.0
2021-03-08 08:00:00	SPY	ETF	381.36	384.071	380.53	383.96	1118357.0
2021-03-08 09:00:00	SPY	ETF	383.96	386.02	382.79	383.99	14079144.0
2021-03-08 10:00:00	SPY	ETF	383.97	387.45	383.32	386.61	17423189.0
2021-03-08 11:00:00	SPY	ETF	386.6	387.36	385.2	385.25	11794118.0
2021-03-08 12:00:00	SPY	ETF	385.25	387.62	385.11	386.7417	8686503.0
2021-03-08 13:00:00	SPY	ETF	386.74	387.68	384.19	384.34	11279530.0
2021-03-08 14:00:00	SPY	ETF	384.34	386.08	383.91	384.76	12467459.0
2021-03-08 15:00:00	SPY	ETF	384.75	384.755	381.42	381.74	19424309.0
2021-03-08 16:00:00	SPY	ETF	381.75	383.11	381.67	382.71	7716285.0
2021-03-08 17:00:00	SPY	ETF	382.9	382.94	382.66	382.81	119968.0
2021-03-08 18:00:00	SPY	ETF	382.96	384.0	382.83	383.6	216291.0
2021-03-08 19:00:00	SPY	ETF	383.63	383.92	382.73	383.33	93141.0
2021-03-08 04:00:00	QQQ	ETF	308.7	309.5	301.8	302.92	183117.0
2021-03-08 05:00:00	QQQ	ETF	302.93	304.0	302.84	303.8	382124.0
2021-03-08 06:00:00	QQQ	ETF	304.1	304.62	303.52	304.48	341784.0
2021-03-08 07:00:00	QQQ	ETF	304.54	305.32	303.68	304.52	828464.0
2021-03-08 08:00:00	QQQ	ETF	304.41	308.68	302.7	307.48	1277568.0
2021-03-08 09:00:00	QQQ	ETF	307.49	309.67	305.48	306.74	12577833.0
2021-03-08 10:00:00	QQQ	ETF	306.74	310.06	305.69	308.07	10526953.0
2021-03-08 11:00:00	QQQ	ETF	308.07	309.05	304.935	305.01	8453779.0
2021-03-08 12:00:00	QQQ	ETF	305.02	306.965	304.39	305.4	6238279.0
2021-03-08 13:00:00	QQQ	ETF	305.41	306.565	302.79	302.96	6152217.0
2021-03-08 14:00:00	QQQ	ETF	302.95	304.71	302.26	302.88	7995036.0
2021-03-08 15:00:00	QQQ	ETF	302.88	302.88	299.51	299.92	12591415.0
2021-03-08 16:00:00	QQQ	ETF	299.92	308.3846	299.76	300.75	1955725.0
2021-03-08 17:00:00	QQQ	ETF	300.66	301.0	300.65	300.91	64064.0
2021-03-08 18:00:00	QQQ	ETF	300.86	301.96	300.86	301.64	257000.0
2021-03-08 19:00:00	QQQ	ETF	301.7	302.0	300.95	301.55	127903.0
2021-03-08 04:00:00	IWM	ETF	216.36	216.36	214.91	215.61	28730.0
2021-03-08 05:00:00	IWM	ETF	215.95	216.41	215.5	215.75	14906.0
2021-03-08 06:00:00	IWM	ETF	215.77	216.45	215.77	216.45	13005.0
2021-03-08 07:00:00	IWM	ETF	216.48	217.22	216.26	216.96	129492.0
2021-03-08 08:00:00	IWM	ETF	216.75	219.78	215.77	219.78	237658.0
2021-03-08 09:00:00	IWM	ETF	219.71	221.75	217.67	219.46	8131289.0
2021-03-08 10:00:00	IWM	ETF	219.45	222.12	218.59	221.6	5425741.0
2021-03-08 11:00:00	IWM	ETF	221.6	222.27	219.99	220.06	3105865.0
2021-03-08 12:00:00	IWM	ETF	220.08	222.2	219.98	221.28	2551581.0
2021-03-08 13:00:00	IWM	ETF	221.34	222.07	218.87	218.95	2705533.0
2021-03-08 14:00:00	IWM	ETF	218.92	221.085	218.86	219.76	2556858.0
2021-03-08 15:00:00	IWM	ETF	219.75	220.3	218.27	218.8	5484591.0
2021-03-08 16:00:00	IWM	ETF	218.8	220.0	218.73	219.94	2642403.0
2021-03-08 17:00:00	IWM	ETF	219.85	219.9	219.53	219.72	4369.0
2021-03-08 18:00:00	IWM	ETF	219.75	220.44	219.75	220.36	23732.0
2021-03-08 19:00:00	IWM	ETF	220.1	220.27	219.42	219.88	25114.0
2021-03-08 04:00:00	DIA	ETF	314.41	314.41	313.59	314.39	340.0
2021-03-08 05:00:00	DIA	ETF	314.39	314.9	314.39	314.72	6100.0

> showing 50 of 15,473 rows — these rows as CSV

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