PREVIEW / etf_1hour / 2007-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-09.parquet
  size:    67 KB
  rows:    2,143

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-09 06:00:00	SPY	ETF	140.63	140.63	140.58	140.58	8400.0
2007-03-09 07:00:00	SPY	ETF	140.57	140.64	140.45	140.59	137400.0
2007-03-09 08:00:00	SPY	ETF	140.56	141.64	140.4	141.48	13117400.0
2007-03-09 09:00:00	SPY	ETF	141.51	141.6	140.72	140.88	15263600.0
2007-03-09 10:00:00	SPY	ETF	140.88	141.35	140.26	140.78	20234800.0
2007-03-09 11:00:00	SPY	ETF	140.78	141.2	140.6299	140.83	9051300.0
2007-03-09 12:00:00	SPY	ETF	140.83	141.05	140.61	140.67	6104500.0
2007-03-09 13:00:00	SPY	ETF	140.67	140.84	140.32	140.34	10998800.0
2007-03-09 14:00:00	SPY	ETF	140.35	140.6	140.08	140.45	14227400.0
2007-03-09 15:00:00	SPY	ETF	140.45	140.88	140.35	140.63	15356900.0
2007-03-09 16:00:00	SPY	ETF	140.62	140.79	140.56	140.77	962600.0
2007-03-09 17:00:00	SPY	ETF	140.77	140.78	140.69	140.75	195100.0
2007-03-09 18:00:00	SPY	ETF	140.72	140.72	140.71	140.72	1500.0
2007-03-09 19:00:00	SPY	ETF	140.7	140.7	140.61	140.61	6700.0
2007-03-09 06:00:00	QQQ	ETF	43.06	43.06	43.06	43.06	1000.0
2007-03-09 07:00:00	QQQ	ETF	43.06	43.09	43.02	43.07	160240.0
2007-03-09 08:00:00	QQQ	ETF	43.07	43.45	43.02	43.38	8130178.0
2007-03-09 09:00:00	QQQ	ETF	43.37	43.42	43.04	43.05	20367794.0
2007-03-09 10:00:00	QQQ	ETF	43.05	43.14	42.88	43.08	30552700.0
2007-03-09 11:00:00	QQQ	ETF	43.08	43.13	43.01	43.02	11061300.0
2007-03-09 12:00:00	QQQ	ETF	43.02	43.11	42.94	42.98	7892900.0
2007-03-09 13:00:00	QQQ	ETF	42.98	43.02	42.77	42.78	11037800.0
2007-03-09 14:00:00	QQQ	ETF	42.78	42.9	42.65	42.89	19068600.0
2007-03-09 15:00:00	QQQ	ETF	42.9	43.02	42.86	42.92	15608200.0
2007-03-09 16:00:00	QQQ	ETF	42.93	43.0	42.91	42.94	2630528.0
2007-03-09 17:00:00	QQQ	ETF	42.94	42.96	42.94	42.94	1480120.0
2007-03-09 18:00:00	QQQ	ETF	42.95	42.96	42.93	42.96	14075.0
2007-03-09 19:00:00	QQQ	ETF	42.96	42.98	42.93	42.98	12635.0
2007-03-09 07:00:00	IWM	ETF	77.88	77.88	77.88	77.88	500.0
2007-03-09 08:00:00	IWM	ETF	77.75	78.41	77.71	78.25	928300.0
2007-03-09 09:00:00	IWM	ETF	78.3	78.36	77.88	77.94	11425700.0
2007-03-09 10:00:00	IWM	ETF	77.94	78.05	77.51	77.89	11312300.0
2007-03-09 11:00:00	IWM	ETF	77.89	78.17	77.81	77.99	6793500.0
2007-03-09 12:00:00	IWM	ETF	77.99	78.26	77.92	77.97	5679900.0
2007-03-09 13:00:00	IWM	ETF	77.96	78.09	77.58	77.59	7200600.0
2007-03-09 14:00:00	IWM	ETF	77.59	77.85	77.42	77.72	9887300.0
2007-03-09 15:00:00	IWM	ETF	77.74	78.15	77.59	78.02	8607600.0
2007-03-09 16:00:00	IWM	ETF	78.01	78.27	78.01	78.1	537900.0
2007-03-09 17:00:00	IWM	ETF	78.25	78.25	78.17	78.17	3704700.0
2007-03-09 07:00:00	DIA	ETF	122.77	122.78	122.77	122.78	3000.0
2007-03-09 08:00:00	DIA	ETF	122.8	123.44	122.63	123.34	96000.0
2007-03-09 09:00:00	DIA	ETF	123.34	123.42	122.92	122.98	1271000.0
2007-03-09 10:00:00	DIA	ETF	122.96	123.04	122.54	122.88	1773200.0
2007-03-09 11:00:00	DIA	ETF	122.89	123.05	122.76	122.87	584100.0
2007-03-09 12:00:00	DIA	ETF	122.87	123.08	122.73	122.81	409600.0
2007-03-09 13:00:00	DIA	ETF	122.8	122.94	122.52	122.56	1217800.0
2007-03-09 14:00:00	DIA	ETF	122.56	122.65	122.33	122.62	1347900.0
2007-03-09 15:00:00	DIA	ETF	122.63	123.01	122.56	122.83	1179900.0
2007-03-09 16:00:00	DIA	ETF	122.83	123.0	122.6537	122.98	654500.0
2007-03-09 17:00:00	DIA	ETF	122.98	123.0	122.98	122.98	40100.0

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

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