PREVIEW / etf_1hour / 2007-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-05.parquet
  size:    61 KB
  rows:    1,918

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-05 04:00:00	SPY	ETF	141.31	141.35	141.31	141.35	1600.0
2007-01-05 07:00:00	SPY	ETF	141.36	141.36	141.01	141.01	276700.0
2007-01-05 08:00:00	SPY	ETF	141.1	141.49	140.98	141.25	5698400.0
2007-01-05 09:00:00	SPY	ETF	141.25	141.4	140.8	140.89	9198800.0
2007-01-05 10:00:00	SPY	ETF	140.93	141.32	140.86	140.98	12800700.0
2007-01-05 11:00:00	SPY	ETF	140.98	141.11	140.38	140.6611	17758700.0
2007-01-05 12:00:00	SPY	ETF	140.66	140.94	140.64	140.788	5347400.0
2007-01-05 13:00:00	SPY	ETF	140.79	140.94	140.58	140.85	6118000.0
2007-01-05 14:00:00	SPY	ETF	140.84	140.92	140.6	140.65	5919800.0
2007-01-05 15:00:00	SPY	ETF	140.65	140.97	140.46	140.76	8353200.0
2007-01-05 16:00:00	SPY	ETF	140.73	140.8131	140.48	140.69	1178500.0
2007-01-05 17:00:00	SPY	ETF	140.69	140.69	140.48	140.48	163500.0
2007-01-05 18:00:00	SPY	ETF	140.53	140.58	140.42	140.42	43600.0
2007-01-05 19:00:00	SPY	ETF	140.44	140.55	140.42	140.44	7800.0
2007-01-05 04:00:00	QQQ	ETF	44.0	44.0	43.98	43.98	1200.0
2007-01-05 06:00:00	QQQ	ETF	43.96	44.02	43.83	43.99	43700.0
2007-01-05 07:00:00	QQQ	ETF	43.96	43.96	43.8	43.83	477920.0
2007-01-05 08:00:00	QQQ	ETF	43.84	44.06	43.8	43.96	11170888.0
2007-01-05 09:00:00	QQQ	ETF	43.96	43.98	43.7	43.71	23934139.0
2007-01-05 10:00:00	QQQ	ETF	43.71	43.93	43.7	43.79	18425500.0
2007-01-05 11:00:00	QQQ	ETF	43.78	43.82	43.48	43.6	24293200.0
2007-01-05 12:00:00	QQQ	ETF	43.6	43.97	43.6	43.72	9887200.0
2007-01-05 13:00:00	QQQ	ETF	43.73	43.89	43.67	43.81	9226300.0
2007-01-05 14:00:00	QQQ	ETF	43.81	43.85	43.7	43.73	7586300.0
2007-01-05 15:00:00	QQQ	ETF	43.73	43.91	43.65	43.84	14274200.0
2007-01-05 16:00:00	QQQ	ETF	43.84	43.86	43.71	43.79	2089566.0
2007-01-05 17:00:00	QQQ	ETF	43.79	43.8	43.75	43.77	6237403.0
2007-01-05 18:00:00	QQQ	ETF	43.76	43.76	43.75	43.75	18380.0
2007-01-05 19:00:00	QQQ	ETF	43.77	43.77	43.76	43.76	28174.0
2007-01-05 08:00:00	IWM	ETF	77.94	78.32	77.61	77.91	2615800.0
2007-01-05 09:00:00	IWM	ETF	77.9	78.05	77.4	77.46	7061800.0
2007-01-05 10:00:00	IWM	ETF	77.47	77.77	77.37	77.37	6541700.0
2007-01-05 11:00:00	IWM	ETF	77.37	77.47	76.78	77.04	13179800.0
2007-01-05 12:00:00	IWM	ETF	77.04	77.3	76.965	77.12	7841800.0
2007-01-05 13:00:00	IWM	ETF	77.12	77.23	76.95	77.12	3498600.0
2007-01-05 14:00:00	IWM	ETF	77.13	77.23	76.89	76.9	3220300.0
2007-01-05 15:00:00	IWM	ETF	76.9	78.3663	76.77	76.96	9252300.0
2007-01-05 16:00:00	IWM	ETF	76.95	76.98	76.7	76.7	301700.0
2007-01-05 18:00:00	IWM	ETF	76.8	76.8	76.8	76.8	1000.0
2007-01-05 08:00:00	DIA	ETF	124.24	124.57	124.22	124.35	135800.0
2007-01-05 09:00:00	DIA	ETF	124.41	124.51	123.97	124.03	1413400.0
2007-01-05 10:00:00	DIA	ETF	124.02	124.33	124.01	124.01	1215900.0
2007-01-05 11:00:00	DIA	ETF	124.01	124.08	123.52	123.83	2047300.0
2007-01-05 12:00:00	DIA	ETF	123.84	124.05	123.79	123.8795	1196600.0
2007-01-05 13:00:00	DIA	ETF	123.89	123.98	123.72	123.86	1006000.0
2007-01-05 14:00:00	DIA	ETF	123.87	123.92	123.67	123.7	774500.0
2007-01-05 15:00:00	DIA	ETF	123.7	123.98	123.55	123.84	1485000.0
2007-01-05 16:00:00	DIA	ETF	123.82	123.88	123.69	123.72	80000.0
2007-01-05 17:00:00	DIA	ETF	123.74	123.78	123.74	123.74	600.0
2007-01-05 19:00:00	DIA	ETF	123.7	123.7	123.7	123.7	300.0

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

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