PREVIEW / etf_1hour / 2020-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-09.parquet
  size:    361 KB
  rows:    11,861

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
2020-01-09 04:00:00	SPY	ETF	326.12	326.23	326.02	326.15	9275.0
2020-01-09 05:00:00	SPY	ETF	326.14	326.29	326.0	326.0	28350.0
2020-01-09 06:00:00	SPY	ETF	326.05	326.22	326.03	326.21	40374.0
2020-01-09 07:00:00	SPY	ETF	326.19	326.37	325.76	325.94	289777.0
2020-01-09 08:00:00	SPY	ETF	326.2	326.36	325.29	326.16	277812.0
2020-01-09 09:00:00	SPY	ETF	326.17	326.47	325.65	326.01	5789438.0
2020-01-09 10:00:00	SPY	ETF	325.985	326.5598	325.71	326.4595	4412637.0
2020-01-09 11:00:00	SPY	ETF	326.47	326.6	326.09	326.52	5969789.0
2020-01-09 12:00:00	SPY	ETF	326.53	326.61	325.52	326.04	6519496.0
2020-01-09 13:00:00	SPY	ETF	326.05	326.44	325.75	326.19	4960792.0
2020-01-09 14:00:00	SPY	ETF	326.19	326.73	326.17	326.5	5198311.0
2020-01-09 15:00:00	SPY	ETF	326.49	326.68	326.115	326.62	10734383.0
2020-01-09 16:00:00	SPY	ETF	326.62	326.75	326.52	326.59	3131692.0
2020-01-09 17:00:00	SPY	ETF	326.59	326.6	326.43	326.57	337019.0
2020-01-09 18:00:00	SPY	ETF	326.6	326.98	326.6	326.9	84388.0
2020-01-09 19:00:00	SPY	ETF	326.88	327.36	326.83	327.22	61638.0
2020-01-09 04:00:00	QQQ	ETF	218.42	218.59	218.42	218.5	30267.0
2020-01-09 05:00:00	QQQ	ETF	218.53	218.61	218.37	218.39	30126.0
2020-01-09 06:00:00	QQQ	ETF	218.38	218.55	218.36	218.49	32450.0
2020-01-09 07:00:00	QQQ	ETF	218.49	218.74	218.27	218.45	162822.0
2020-01-09 08:00:00	QQQ	ETF	218.43	218.85	217.72	218.76	284091.0
2020-01-09 09:00:00	QQQ	ETF	218.77	219.41	218.68	218.96	3892622.0
2020-01-09 10:00:00	QQQ	ETF	218.97	219.3	218.69	219.1519	2397068.0
2020-01-09 11:00:00	QQQ	ETF	219.16	219.1979	218.7299	219.04	1932317.0
2020-01-09 12:00:00	QQQ	ETF	219.04	219.09	217.7125	218.39	2871967.0
2020-01-09 13:00:00	QQQ	ETF	218.39	218.82	218.2	218.64	2042485.0
2020-01-09 14:00:00	QQQ	ETF	218.64	218.99	218.56	218.83	1344582.0
2020-01-09 15:00:00	QQQ	ETF	218.825	219.04	218.48	219.01	3042804.0
2020-01-09 16:00:00	QQQ	ETF	219.01	219.09	218.9	219.07	1210970.0
2020-01-09 17:00:00	QQQ	ETF	219.1	219.1	218.97	219.01	84774.0
2020-01-09 18:00:00	QQQ	ETF	219.05	219.29	219.05	219.26	56846.0
2020-01-09 19:00:00	QQQ	ETF	219.24	219.62	219.24	219.5601	65391.0
2020-01-09 04:00:00	IWM	ETF	166.24	166.25	166.24	166.25	539.0
2020-01-09 05:00:00	IWM	ETF	166.05	166.06	165.97	165.97	10950.0
2020-01-09 06:00:00	IWM	ETF	166.04	166.16	166.0	166.12	9700.0
2020-01-09 07:00:00	IWM	ETF	166.09	166.1	165.95	165.95	27872.0
2020-01-09 08:00:00	IWM	ETF	165.95	166.31	165.95	166.09	40285.0
2020-01-09 09:00:00	IWM	ETF	166.09	166.18	165.38	165.89	1780829.0
2020-01-09 10:00:00	IWM	ETF	165.89	166.45	165.66	166.17	1837233.0
2020-01-09 11:00:00	IWM	ETF	166.17	166.21	165.8	166.03	925561.0
2020-01-09 12:00:00	IWM	ETF	166.03	166.13	165.26	165.65	945023.0
2020-01-09 13:00:00	IWM	ETF	165.66	165.74	165.48	165.54	651338.0
2020-01-09 14:00:00	IWM	ETF	165.535	165.915	165.51	165.79	788794.0
2020-01-09 15:00:00	IWM	ETF	165.775	165.8	165.33	165.55	2585761.0
2020-01-09 16:00:00	IWM	ETF	165.56	165.59	165.41	165.54	1102588.0
2020-01-09 17:00:00	IWM	ETF	165.49	165.51	165.49	165.51	1800.0
2020-01-09 18:00:00	IWM	ETF	165.51	165.67	165.51	165.67	3200.0
2020-01-09 19:00:00	IWM	ETF	165.66	165.89	165.66	165.77	14640.0
2020-01-09 05:00:00	DIA	ETF	288.96	288.96	288.76	288.76	461.0
2020-01-09 06:00:00	DIA	ETF	288.91	288.97	288.91	288.97	200.0

> showing 50 of 11,861 rows — these rows as CSV

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