PREVIEW / etf_1hour / 2007-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-16.parquet
  size:    62 KB
  rows:    1,971

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-01-16 06:00:00	SPY	ETF	143.37	143.37	143.28	143.29	22500.0
2007-01-16 07:00:00	SPY	ETF	143.28	143.35	143.28	143.31	14700.0
2007-01-16 08:00:00	SPY	ETF	143.31	143.35	143.13	143.18	416300.0
2007-01-16 09:00:00	SPY	ETF	143.19	143.44	142.97	143.23	6048400.0
2007-01-16 10:00:00	SPY	ETF	143.22	143.23	142.78	142.82	7841400.0
2007-01-16 11:00:00	SPY	ETF	142.8	143.09	142.8	142.97	8157400.0
2007-01-16 12:00:00	SPY	ETF	142.97	143.18	142.79	142.87	4095000.0
2007-01-16 13:00:00	SPY	ETF	142.87	142.93	142.73	142.85	3518600.0
2007-01-16 14:00:00	SPY	ETF	142.86	143.08	142.8	142.98	3380900.0
2007-01-16 15:00:00	SPY	ETF	142.99	143.19	142.9	143.03	7389300.0
2007-01-16 16:00:00	SPY	ETF	143.03	143.07	142.86	142.91	979500.0
2007-01-16 17:00:00	SPY	ETF	142.9	142.91	142.89	142.89	156700.0
2007-01-16 18:00:00	SPY	ETF	142.9	142.9	142.83	142.85	116600.0
2007-01-16 19:00:00	SPY	ETF	142.85	142.85	142.83	142.83	1600.0
2007-01-16 06:00:00	QQQ	ETF	45.43	45.43	45.43	45.43	27200.0
2007-01-16 07:00:00	QQQ	ETF	45.43	45.47	45.42	45.43	420614.0
2007-01-16 08:00:00	QQQ	ETF	45.45	45.46	45.33	45.37	1415982.0
2007-01-16 09:00:00	QQQ	ETF	45.37	45.4	45.26	45.36	12901738.0
2007-01-16 10:00:00	QQQ	ETF	45.35	45.38	45.13	45.15	17569800.0
2007-01-16 11:00:00	QQQ	ETF	45.16	45.32	45.14	45.28	11574300.0
2007-01-16 12:00:00	QQQ	ETF	45.27	45.39	45.19	45.23	10674100.0
2007-01-16 13:00:00	QQQ	ETF	45.22	45.26	45.13	45.19	7569500.0
2007-01-16 14:00:00	QQQ	ETF	45.19	45.33	45.15	45.25	10022100.0
2007-01-16 15:00:00	QQQ	ETF	45.25	45.29	45.18	45.27	9603400.0
2007-01-16 16:00:00	QQQ	ETF	45.28	45.35	45.17	45.18	6759776.0
2007-01-16 17:00:00	QQQ	ETF	45.18	45.18	45.08	45.1	676852.0
2007-01-16 18:00:00	QQQ	ETF	45.12	45.14	45.06	45.07	224414.0
2007-01-16 19:00:00	QQQ	ETF	45.07	45.11	45.07	45.1	42795.0
2007-01-16 08:00:00	IWM	ETF	79.27	79.29	79.15	79.17	125100.0
2007-01-16 09:00:00	IWM	ETF	79.2	79.36	79.02	79.07	4226700.0
2007-01-16 10:00:00	IWM	ETF	79.07	79.1	78.67	78.77	4899500.0
2007-01-16 11:00:00	IWM	ETF	78.76	78.95	78.75	78.85	2872700.0
2007-01-16 12:00:00	IWM	ETF	78.87	79.0	78.59	78.68	3489200.0
2007-01-16 13:00:00	IWM	ETF	78.67	78.73	78.39	78.45	4062800.0
2007-01-16 14:00:00	IWM	ETF	78.45	78.55	78.37	78.41	3783400.0
2007-01-16 15:00:00	IWM	ETF	78.4	78.53	78.3	78.49	6091600.0
2007-01-16 16:00:00	IWM	ETF	78.49	79.0	78.31	78.35	1875200.0
2007-01-16 17:00:00	IWM	ETF	78.31	78.31	78.31	78.31	1195300.0
2007-01-16 18:00:00	IWM	ETF	78.31	78.31	78.28	78.28	2500.0
2007-01-16 07:00:00	DIA	ETF	125.86	125.86	125.83	125.83	1300.0
2007-01-16 08:00:00	DIA	ETF	125.84	125.84	125.6	125.64	5500.0
2007-01-16 09:00:00	DIA	ETF	125.64	125.75	125.48	125.62	884600.0
2007-01-16 10:00:00	DIA	ETF	125.62	125.66	125.29	125.33	1338900.0
2007-01-16 11:00:00	DIA	ETF	125.33	125.57	125.33	125.49	770200.0
2007-01-16 12:00:00	DIA	ETF	125.49	125.61	125.35	125.44	687200.0
2007-01-16 13:00:00	DIA	ETF	125.44	125.48	125.32	125.4399	974100.0
2007-01-16 14:00:00	DIA	ETF	125.4301	125.65	125.38	125.56	823000.0
2007-01-16 15:00:00	DIA	ETF	125.56	125.74	125.53	125.69	930400.0
2007-01-16 16:00:00	DIA	ETF	125.67	125.73	125.6	125.61	33100.0
2007-01-16 17:00:00	DIA	ETF	125.64	125.64	125.6	125.61	73900.0

> showing 50 of 1,971 rows — these rows as CSV

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