PREVIEW / etf_1hour / 2007-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-12.parquet
  size:    65 KB
  rows:    2,041

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-12 06:00:00	SPY	ETF	140.98	140.98	140.87	140.87	5500.0
2007-03-12 07:00:00	SPY	ETF	140.93	140.96	140.74	140.74	81200.0
2007-03-12 08:00:00	SPY	ETF	140.74	140.98	140.15	140.4	2485800.0
2007-03-12 09:00:00	SPY	ETF	140.33	140.65	140.16	140.26	9940000.0
2007-03-12 10:00:00	SPY	ETF	140.26	140.67	140.21	140.43	13456400.0
2007-03-12 11:00:00	SPY	ETF	140.43	140.49	140.24	140.4375	5828600.0
2007-03-12 12:00:00	SPY	ETF	140.44	140.78	140.39	140.71	7670500.0
2007-03-12 13:00:00	SPY	ETF	140.72	140.75	140.56	140.74	3829000.0
2007-03-12 14:00:00	SPY	ETF	140.74	141.34	140.65	141.21	18846500.0
2007-03-12 15:00:00	SPY	ETF	141.2	141.24	140.76	141.01	11716200.0
2007-03-12 16:00:00	SPY	ETF	141.01	141.26	140.3	140.98	3406500.0
2007-03-12 17:00:00	SPY	ETF	140.98	141.05	140.96	140.96	1193300.0
2007-03-12 18:00:00	SPY	ETF	140.96	140.97	140.95	140.95	7400.0
2007-03-12 19:00:00	SPY	ETF	140.97	140.97	140.91	140.92	9900.0
2007-03-12 04:00:00	QQQ	ETF	43.11	43.11	43.11	43.11	200.0
2007-03-12 06:00:00	QQQ	ETF	43.12	43.15	43.06	43.06	10700.0
2007-03-12 07:00:00	QQQ	ETF	43.1	43.13	43.0	43.0	83200.0
2007-03-12 08:00:00	QQQ	ETF	43.0	43.01	42.78	42.8	852365.0
2007-03-12 09:00:00	QQQ	ETF	42.8	43.09	42.8	42.95	13918223.0
2007-03-12 10:00:00	QQQ	ETF	42.94	43.11	42.88	43.0	12933500.0
2007-03-12 11:00:00	QQQ	ETF	43.0	43.03	42.93	42.98	6498311.0
2007-03-12 12:00:00	QQQ	ETF	42.99	43.11	42.95	43.11	6413800.0
2007-03-12 13:00:00	QQQ	ETF	43.11	43.12	43.02	43.1	4803600.0
2007-03-12 14:00:00	QQQ	ETF	43.1	43.28	42.93	43.23	16847100.0
2007-03-12 15:00:00	QQQ	ETF	43.22	43.26	43.08	43.22	15648900.0
2007-03-12 16:00:00	QQQ	ETF	43.22	43.2475	42.995	43.18	2365977.0
2007-03-12 17:00:00	QQQ	ETF	43.2	43.25	43.17	43.18	306179.0
2007-03-12 18:00:00	QQQ	ETF	43.18	43.21	43.17	43.17	10245.0
2007-03-12 19:00:00	QQQ	ETF	43.19	43.21	43.17	43.2	20514.0
2007-03-12 07:00:00	IWM	ETF	78.16	78.16	78.15	78.15	1900.0
2007-03-12 08:00:00	IWM	ETF	78.27	78.45	77.81	77.89	332300.0
2007-03-12 09:00:00	IWM	ETF	77.88	78.18	77.77	77.81	5162400.0
2007-03-12 10:00:00	IWM	ETF	77.82	78.15	77.75	78.01	5669600.0
2007-03-12 11:00:00	IWM	ETF	78.02	78.07	77.8	77.97	3587300.0
2007-03-12 12:00:00	IWM	ETF	77.97	78.15	77.92	78.08	2983700.0
2007-03-12 13:00:00	IWM	ETF	78.08	78.13	77.95	78.1	4698500.0
2007-03-12 14:00:00	IWM	ETF	78.11	78.51	78.04	78.45	6570500.0
2007-03-12 15:00:00	IWM	ETF	78.45	78.47	78.17	78.4	5608400.0
2007-03-12 16:00:00	IWM	ETF	78.4	78.47	77.885	78.37	880900.0
2007-03-12 17:00:00	IWM	ETF	78.37	78.5	77.88	78.34	31100.0
2007-03-12 18:00:00	IWM	ETF	78.36	78.38	78.36	78.36	9500.0
2007-03-12 19:00:00	IWM	ETF	78.4	78.4	78.4	78.4	6107600.0
2007-03-12 07:00:00	DIA	ETF	122.99	123.12	122.99	123.12	17200.0
2007-03-12 08:00:00	DIA	ETF	123.01	123.01	122.6	122.69	32800.0
2007-03-12 09:00:00	DIA	ETF	122.71	122.9	122.52	122.58	1098800.0
2007-03-12 10:00:00	DIA	ETF	122.59	122.95	122.53	122.8	1330500.0
2007-03-12 11:00:00	DIA	ETF	122.8	122.85	122.63	122.749	563000.0
2007-03-12 12:00:00	DIA	ETF	122.74	123.04	122.73	123.0	535700.0
2007-03-12 13:00:00	DIA	ETF	123.0	123.08	122.9	123.0775	293500.0
2007-03-12 14:00:00	DIA	ETF	123.07	123.53	123.0	123.39	1163200.0

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

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