PREVIEW / etf_1hour / 2019-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-31.parquet
  size:    360 KB
  rows:    11,976

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
2019-12-31 04:00:00	SPY	ETF	321.42	321.44	321.37	321.4	6550.0
2019-12-31 05:00:00	SPY	ETF	321.4	321.65	321.35	321.6	4115.0
2019-12-31 06:00:00	SPY	ETF	321.6	321.6	321.2	321.23	7755.0
2019-12-31 07:00:00	SPY	ETF	321.3	321.3	320.86	320.9	159229.0
2019-12-31 08:00:00	SPY	ETF	320.9	321.39	320.55	320.59	225470.0
2019-12-31 09:00:00	SPY	ETF	320.61	321.54	320.15	321.28	4299304.0
2019-12-31 10:00:00	SPY	ETF	321.28	321.35	320.41	320.42	4897845.0
2019-12-31 11:00:00	SPY	ETF	320.41	320.88	320.302	320.61	3685862.0
2019-12-31 12:00:00	SPY	ETF	320.61	320.77	320.41	320.67	3093818.0
2019-12-31 13:00:00	SPY	ETF	320.67	320.94	320.655	320.92	3026206.0
2019-12-31 14:00:00	SPY	ETF	320.92	321.09	320.74	320.94	3508079.0
2019-12-31 15:00:00	SPY	ETF	320.94	322.13	320.89	321.89	15847203.0
2019-12-31 16:00:00	SPY	ETF	321.87	322.43	321.0754	322.39	16341025.0
2019-12-31 17:00:00	SPY	ETF	322.36	322.4	322.22	322.23	147900.0
2019-12-31 18:00:00	SPY	ETF	322.23	322.35	322.22	322.32	24210.0
2019-12-31 19:00:00	SPY	ETF	322.36	322.43	322.33	322.35	21682.0
2019-12-31 04:00:00	QQQ	ETF	212.39	212.42	212.35	212.36	5602.0
2019-12-31 05:00:00	QQQ	ETF	212.42	212.45	212.41	212.43	1300.0
2019-12-31 06:00:00	QQQ	ETF	212.32	212.35	212.15	212.19	5650.0
2019-12-31 07:00:00	QQQ	ETF	212.22	212.26	211.9	211.92	108450.0
2019-12-31 08:00:00	QQQ	ETF	211.91	212.6	211.6	211.68	214053.0
2019-12-31 09:00:00	QQQ	ETF	211.64	212.52	211.2	212.28	3280120.0
2019-12-31 10:00:00	QQQ	ETF	212.285	212.39	211.6	211.668	2196047.0
2019-12-31 11:00:00	QQQ	ETF	211.66	212.03	211.51	211.88	1868325.0
2019-12-31 12:00:00	QQQ	ETF	211.885	212.02	211.75	211.94	1014578.0
2019-12-31 13:00:00	QQQ	ETF	211.9358	212.125	211.9	212.105	737238.0
2019-12-31 14:00:00	QQQ	ETF	212.1	212.24	211.83	212.17	1438014.0
2019-12-31 15:00:00	QQQ	ETF	212.17	212.76	212.14	212.58	3225935.0
2019-12-31 16:00:00	QQQ	ETF	212.57	213.12	212.57	213.12	875426.0
2019-12-31 17:00:00	QQQ	ETF	213.03	213.05	212.61	213.0	453802.0
2019-12-31 18:00:00	QQQ	ETF	213.0	213.25	213.0	213.08	40207.0
2019-12-31 19:00:00	QQQ	ETF	213.1	213.18	213.03	213.09	25164.0
2019-12-31 07:00:00	IWM	ETF	165.44	165.44	165.32	165.33	16500.0
2019-12-31 08:00:00	IWM	ETF	165.3001	165.49	165.11	165.19	15543.0
2019-12-31 09:00:00	IWM	ETF	165.13	166.3365	164.71	166.26	1355623.0
2019-12-31 10:00:00	IWM	ETF	166.2621	166.32	165.584	165.63	1317166.0
2019-12-31 11:00:00	IWM	ETF	165.63	166.18	165.59	166.18	1112306.0
2019-12-31 12:00:00	IWM	ETF	166.17	166.2	165.88	166.05	958930.0
2019-12-31 13:00:00	IWM	ETF	166.05	166.2	165.97	166.17	760197.0
2019-12-31 14:00:00	IWM	ETF	166.17	166.35	166.125	166.15	828130.0
2019-12-31 15:00:00	IWM	ETF	166.15	166.22	165.66	165.69	4879677.0
2019-12-31 16:00:00	IWM	ETF	165.7	166.09	165.4051	165.4051	3133172.0
2019-12-31 17:00:00	IWM	ETF	166.05	166.08	165.67	166.0	135085.0
2019-12-31 18:00:00	IWM	ETF	166.0	166.0	166.0	166.0	116.0
2019-12-31 19:00:00	IWM	ETF	166.04	166.1	166.04	166.1	5292.0
2019-12-31 07:00:00	DIA	ETF	284.53	284.53	284.18	284.18	2571.0
2019-12-31 08:00:00	DIA	ETF	284.2901	284.55	284.0	284.02	4318.0
2019-12-31 09:00:00	DIA	ETF	283.93	284.69	283.56	284.5	158622.0
2019-12-31 10:00:00	DIA	ETF	284.42	284.49	283.66	283.71	174360.0
2019-12-31 11:00:00	DIA	ETF	283.66	284.21	283.66	284.03	137746.0

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

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