PREVIEW / etf_1hour / 2007-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-09.parquet
  size:    79 KB
  rows:    2,747

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
2007-07-09 06:00:00	SPY	ETF	153.18	153.23	153.18	153.23	28500.0
2007-07-09 07:00:00	SPY	ETF	153.18	153.33	153.14	153.26	48400.0
2007-07-09 08:00:00	SPY	ETF	153.19	153.33	152.95	153.12	387000.0
2007-07-09 09:00:00	SPY	ETF	153.1	153.33	153.02	153.1	12560208.0
2007-07-09 10:00:00	SPY	ETF	153.11	153.28	152.62	152.64	15205068.0
2007-07-09 11:00:00	SPY	ETF	152.64	153.0	152.63	152.92	7002420.0
2007-07-09 12:00:00	SPY	ETF	152.93	153.12	152.81	153.0601	6264683.0
2007-07-09 13:00:00	SPY	ETF	153.06	153.17	152.92	153.13	4828841.0
2007-07-09 14:00:00	SPY	ETF	153.14	153.31	152.86	153.27	10228187.0
2007-07-09 15:00:00	SPY	ETF	153.28	153.36	153.07	153.09	11850652.0
2007-07-09 16:00:00	SPY	ETF	153.1	153.1881	152.97	153.07	1358600.0
2007-07-09 17:00:00	SPY	ETF	153.09	153.12	152.96	153.0	311600.0
2007-07-09 18:00:00	SPY	ETF	153.0	153.07	152.96	153.0	670800.0
2007-07-09 19:00:00	SPY	ETF	152.99	153.06	152.96	153.06	4500.0
2007-07-09 06:00:00	QQQ	ETF	48.95	48.95	48.95	48.95	3000.0
2007-07-09 07:00:00	QQQ	ETF	48.94	48.99	48.94	48.96	122714.0
2007-07-09 08:00:00	QQQ	ETF	48.95	48.99	48.89	48.9	671271.0
2007-07-09 09:00:00	QQQ	ETF	48.9	48.95	48.81	48.845	12850324.0
2007-07-09 10:00:00	QQQ	ETF	48.8499	48.97	48.72	48.76	15642742.0
2007-07-09 11:00:00	QQQ	ETF	48.75	48.9	48.75	48.8815	5037163.0
2007-07-09 12:00:00	QQQ	ETF	48.88	48.93	48.84	48.9	5444624.0
2007-07-09 13:00:00	QQQ	ETF	48.902	48.95	48.87	48.94	3836093.0
2007-07-09 14:00:00	QQQ	ETF	48.93	48.97	48.83	48.96	7051416.0
2007-07-09 15:00:00	QQQ	ETF	48.95	48.98	48.9	48.91	8658722.0
2007-07-09 16:00:00	QQQ	ETF	48.91	48.94	48.88	48.93	3696961.0
2007-07-09 17:00:00	QQQ	ETF	48.94	48.95	48.9	48.9	228458.0
2007-07-09 18:00:00	QQQ	ETF	48.9	48.93	48.88	48.89	511941.0
2007-07-09 19:00:00	QQQ	ETF	48.89	48.92	48.89	48.92	2665.0
2007-07-09 07:00:00	IWM	ETF	85.0	85.0	85.0	85.0	13600.0
2007-07-09 08:00:00	IWM	ETF	85.0	85.0	84.87	84.88	49700.0
2007-07-09 09:00:00	IWM	ETF	84.88	85.03	84.74	84.75	6185983.0
2007-07-09 10:00:00	IWM	ETF	84.75	84.94	84.42	84.43	7208265.0
2007-07-09 11:00:00	IWM	ETF	84.43	84.72	84.42	84.7	3631854.0
2007-07-09 12:00:00	IWM	ETF	84.7	84.76	84.57	84.74	3987002.0
2007-07-09 13:00:00	IWM	ETF	84.72	84.85	84.68	84.83	2321105.0
2007-07-09 14:00:00	IWM	ETF	84.82	84.95	84.67	84.9	3670467.0
2007-07-09 15:00:00	IWM	ETF	84.9	84.97	84.79	84.79	3645095.0
2007-07-09 16:00:00	IWM	ETF	84.79	85.74	84.66	84.85	10561000.0
2007-07-09 17:00:00	IWM	ETF	84.86	85.74	84.75	84.78	1215100.0
2007-07-09 18:00:00	IWM	ETF	84.78	84.9	84.78	84.89	277300.0
2007-07-09 19:00:00	IWM	ETF	84.89	85.01	84.86	84.98	323000.0
2007-07-09 07:00:00	DIA	ETF	136.41	136.41	136.32	136.32	2900.0
2007-07-09 08:00:00	DIA	ETF	136.44	136.5	136.33	136.33	207000.0
2007-07-09 09:00:00	DIA	ETF	136.36	136.54	136.28	136.39	1096160.0
2007-07-09 10:00:00	DIA	ETF	136.38	136.55	136.13	136.15	1744002.0
2007-07-09 11:00:00	DIA	ETF	136.15	136.46	136.14	136.38	1153514.0
2007-07-09 12:00:00	DIA	ETF	136.37	136.62	136.27	136.56	1310100.0
2007-07-09 13:00:00	DIA	ETF	136.55	136.68	136.41	136.65	888300.0
2007-07-09 14:00:00	DIA	ETF	136.66	136.67	136.44	136.62	1537600.0
2007-07-09 15:00:00	DIA	ETF	136.6	136.69	136.46	136.51	1643685.0

> showing 50 of 2,747 rows — these rows as CSV

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