PREVIEW / etf_1hour / 2021-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-19.parquet
  size:    427 KB
  rows:    14,894

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-05-19 04:00:00	SPY	ETF	409.6	410.15	408.37	408.7	42038.0
2021-05-19 05:00:00	SPY	ETF	408.67	409.73	408.2	408.41	80789.0
2021-05-19 06:00:00	SPY	ETF	408.35	408.88	408.16	408.66	61088.0
2021-05-19 07:00:00	SPY	ETF	408.75	408.75	407.33	407.62	633110.0
2021-05-19 08:00:00	SPY	ETF	408.6101	410.85	406.34	406.65	1240905.0
2021-05-19 09:00:00	SPY	ETF	406.63	407.64	405.84	406.95	12316091.0
2021-05-19 10:00:00	SPY	ETF	406.9	407.41	405.33	407.06	16545814.0
2021-05-19 11:00:00	SPY	ETF	407.05	408.43	406.45	408.33	8874397.0
2021-05-19 12:00:00	SPY	ETF	408.32	409.42	407.953	409.16	5636045.0
2021-05-19 13:00:00	SPY	ETF	409.14	410.25	408.925	409.4	5026898.0
2021-05-19 14:00:00	SPY	ETF	409.41	410.56	407.59	408.18	13437175.0
2021-05-19 15:00:00	SPY	ETF	408.19	411.05	407.6	410.89	19737056.0
2021-05-19 16:00:00	SPY	ETF	410.89	411.1	410.2	410.54	3725508.0
2021-05-19 17:00:00	SPY	ETF	410.45	410.65	410.45	410.65	92070.0
2021-05-19 18:00:00	SPY	ETF	410.58	410.86	409.78	409.8	95380.0
2021-05-19 19:00:00	SPY	ETF	409.81	409.99	409.67	409.81	36215.0
2021-05-19 04:00:00	QQQ	ETF	319.96	319.96	317.82	318.21	99232.0
2021-05-19 05:00:00	QQQ	ETF	318.17	319.12	317.59	317.78	78431.0
2021-05-19 06:00:00	QQQ	ETF	317.82	318.64	317.68	318.39	97612.0
2021-05-19 07:00:00	QQQ	ETF	318.4	318.56	316.97	317.17	478833.0
2021-05-19 08:00:00	QQQ	ETF	317.17	320.96	316.22	316.58	639479.0
2021-05-19 09:00:00	QQQ	ETF	316.54	318.91	315.96	318.09	9134951.0
2021-05-19 10:00:00	QQQ	ETF	318.05	319.87	317.14	319.33	9841174.0
2021-05-19 11:00:00	QQQ	ETF	319.32	320.65	318.735	320.25	5702295.0
2021-05-19 12:00:00	QQQ	ETF	320.23	321.2	319.83	320.68	4038669.0
2021-05-19 13:00:00	QQQ	ETF	320.68	321.83	320.57	321.01	3593681.0
2021-05-19 14:00:00	QQQ	ETF	321.02	322.9	319.54	320.62	10100990.0
2021-05-19 15:00:00	QQQ	ETF	320.62	322.83	320.05	322.61	8503808.0
2021-05-19 16:00:00	QQQ	ETF	322.61	322.8	319.5	322.25	1346406.0
2021-05-19 17:00:00	QQQ	ETF	322.19	322.59	322.09	322.32	68961.0
2021-05-19 18:00:00	QQQ	ETF	322.32	322.52	321.47	321.47	230990.0
2021-05-19 19:00:00	QQQ	ETF	321.46	321.65	321.38	321.5	115236.0
2021-05-19 04:00:00	IWM	ETF	218.25	218.27	217.3	217.31	11214.0
2021-05-19 05:00:00	IWM	ETF	217.67	218.26	217.3	217.42	39915.0
2021-05-19 06:00:00	IWM	ETF	217.2	217.81	217.14	217.78	30160.0
2021-05-19 07:00:00	IWM	ETF	217.74	217.74	216.54	216.6	95650.0
2021-05-19 08:00:00	IWM	ETF	216.6	219.24	215.66	215.83	198065.0
2021-05-19 09:00:00	IWM	ETF	215.9	216.68	214.91	215.51	5084009.0
2021-05-19 10:00:00	IWM	ETF	215.49	216.1	214.05	215.98	5847409.0
2021-05-19 11:00:00	IWM	ETF	215.96	216.43	215.03	216.24	2507011.0
2021-05-19 12:00:00	IWM	ETF	216.23	216.84	215.81	216.46	1732196.0
2021-05-19 13:00:00	IWM	ETF	216.4601	217.2	216.3	216.83	1555986.0
2021-05-19 14:00:00	IWM	ETF	216.82	217.835	215.51	216.62	3533154.0
2021-05-19 15:00:00	IWM	ETF	216.62	218.16	216.45	217.94	4234549.0
2021-05-19 16:00:00	IWM	ETF	217.95	218.14	217.35	217.89	868847.0
2021-05-19 17:00:00	IWM	ETF	218.0	218.0	217.72	217.88	41518.0
2021-05-19 18:00:00	IWM	ETF	217.91	218.1	217.3	217.3	56917.0
2021-05-19 19:00:00	IWM	ETF	217.4	217.47	217.22	217.35	6812.0
2021-05-19 04:00:00	DIA	ETF	338.93	338.93	338.6	338.6	4117.0
2021-05-19 05:00:00	DIA	ETF	338.98	339.67	338.76	338.76	6617.0

> showing 50 of 14,894 rows — these rows as CSV

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