PREVIEW / etf_1hour / 2007-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-08.parquet
  size:    68 KB
  rows:    2,159

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-03-08 04:00:00	SPY	ETF	140.41	140.54	140.41	140.54	6200.0
2007-03-08 06:00:00	SPY	ETF	140.66	140.66	140.49	140.5	133300.0
2007-03-08 07:00:00	SPY	ETF	140.51	140.73	140.5	140.65	1369600.0
2007-03-08 08:00:00	SPY	ETF	140.62	140.74	140.47	140.6	3694000.0
2007-03-08 09:00:00	SPY	ETF	140.58	140.84	139.78	140.59	12665000.0
2007-03-08 10:00:00	SPY	ETF	140.6	141.12	140.58	140.88	21715800.0
2007-03-08 11:00:00	SPY	ETF	140.88	141.15	140.71	140.94	11653200.0
2007-03-08 12:00:00	SPY	ETF	140.94	141.04	140.77	140.94	5679800.0
2007-03-08 13:00:00	SPY	ETF	140.94	141.16	140.85	141.02	5699500.0
2007-03-08 14:00:00	SPY	ETF	141.02	141.06	140.07	140.58	23692600.0
2007-03-08 15:00:00	SPY	ETF	140.58	140.76	140.25	140.54	17361600.0
2007-03-08 16:00:00	SPY	ETF	140.55	140.8	140.47	140.72	11456400.0
2007-03-08 17:00:00	SPY	ETF	140.72	140.78	140.66	140.74	181400.0
2007-03-08 18:00:00	SPY	ETF	140.73	140.75	140.69	140.75	8400.0
2007-03-08 19:00:00	SPY	ETF	140.75	140.76	140.73	140.76	5200.0
2007-03-08 04:00:00	QQQ	ETF	42.97	43.03	42.97	43.03	1900.0
2007-03-08 06:00:00	QQQ	ETF	43.12	43.12	43.11	43.11	700.0
2007-03-08 07:00:00	QQQ	ETF	43.1	43.24	43.09	43.2	1416310.0
2007-03-08 08:00:00	QQQ	ETF	43.2	43.23	43.1	43.18	4592075.0
2007-03-08 09:00:00	QQQ	ETF	43.18	43.22	43.03	43.05	18496790.0
2007-03-08 10:00:00	QQQ	ETF	43.05	43.24	43.01	43.16	24351900.0
2007-03-08 11:00:00	QQQ	ETF	43.17	43.23	43.11	43.17	12389500.0
2007-03-08 12:00:00	QQQ	ETF	43.18	43.22	43.1	43.15	5678700.0
2007-03-08 13:00:00	QQQ	ETF	43.16	43.23	43.12	43.17	5411800.0
2007-03-08 14:00:00	QQQ	ETF	43.17	43.17	42.84	42.99	22147700.0
2007-03-08 15:00:00	QQQ	ETF	42.99	43.15	42.88	42.96	13892500.0
2007-03-08 16:00:00	QQQ	ETF	42.97	43.19	42.97	43.14	10341834.0
2007-03-08 17:00:00	QQQ	ETF	43.14	43.19	43.12	43.14	259192.0
2007-03-08 18:00:00	QQQ	ETF	43.15	43.15	43.12	43.14	66208.0
2007-03-08 19:00:00	QQQ	ETF	43.15	43.15	43.12	43.14	10700.0
2007-03-08 07:00:00	IWM	ETF	77.5	77.94	77.5	77.85	122100.0
2007-03-08 08:00:00	IWM	ETF	77.8	77.89	77.64	77.75	829500.0
2007-03-08 09:00:00	IWM	ETF	77.75	78.07	77.6	77.63	10410000.0
2007-03-08 10:00:00	IWM	ETF	77.63	78.06	77.57	77.99	9177100.0
2007-03-08 11:00:00	IWM	ETF	78.0	78.13	77.84	77.97	12743300.0
2007-03-08 12:00:00	IWM	ETF	77.97	78.09	77.93	78.06	3282500.0
2007-03-08 13:00:00	IWM	ETF	78.06	78.18	78.02	78.08	3224400.0
2007-03-08 14:00:00	IWM	ETF	78.08	78.09	77.078	77.67	16832100.0
2007-03-08 15:00:00	IWM	ETF	77.66	77.82	77.42	77.64	12179800.0
2007-03-08 16:00:00	IWM	ETF	77.67	78.01	77.65	77.88	1091800.0
2007-03-08 17:00:00	IWM	ETF	77.84	77.95	77.84	77.94	6700.0
2007-03-08 18:00:00	IWM	ETF	77.94	77.94	77.88	77.91	5700.0
2007-03-08 19:00:00	IWM	ETF	77.91	77.92	77.91	77.91	2500.0
2007-03-08 07:00:00	DIA	ETF	122.8	122.8	122.75	122.76	18700.0
2007-03-08 08:00:00	DIA	ETF	122.82	122.82	122.65	122.73	41500.0
2007-03-08 09:00:00	DIA	ETF	122.66	122.86	122.52	122.67	850900.0
2007-03-08 10:00:00	DIA	ETF	122.67	123.03	122.67	122.9	1320700.0
2007-03-08 11:00:00	DIA	ETF	122.91	123.08	122.76	122.94	605000.0
2007-03-08 12:00:00	DIA	ETF	122.93	123.0	122.77	122.89	638800.0
2007-03-08 13:00:00	DIA	ETF	122.88	123.07	122.83	123.0	517800.0

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

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