PREVIEW / etf_1hour / 2007-04-03

all etf 1-hour files

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

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-04-03 04:00:00	SPY	ETF	142.71	142.71	142.71	142.71	400.0
2007-04-03 05:00:00	SPY	ETF	142.79	142.8	142.79	142.8	6000.0
2007-04-03 07:00:00	SPY	ETF	142.78	142.94	142.7	142.94	255700.0
2007-04-03 08:00:00	SPY	ETF	142.85	143.1	142.7	142.99	1760100.0
2007-04-03 09:00:00	SPY	ETF	142.98	143.07	142.16	142.93	9931801.0
2007-04-03 10:00:00	SPY	ETF	142.94	143.7	142.935	143.62	23620320.0
2007-04-03 11:00:00	SPY	ETF	143.62	143.75	143.52	143.7	9262745.0
2007-04-03 12:00:00	SPY	ETF	143.7	143.71	143.57	143.61	3436690.0
2007-04-03 13:00:00	SPY	ETF	143.61	143.98	143.57	143.8	8045090.0
2007-04-03 14:00:00	SPY	ETF	143.79	143.86	143.58	143.6086	9518865.0
2007-04-03 15:00:00	SPY	ETF	143.61	143.75	143.58	143.66	10608997.0
2007-04-03 16:00:00	SPY	ETF	143.65	143.72	143.62	143.68	4121000.0
2007-04-03 17:00:00	SPY	ETF	143.66	143.68	143.64	143.68	9200.0
2007-04-03 18:00:00	SPY	ETF	143.66	143.75	143.66	143.75	82200.0
2007-04-03 19:00:00	SPY	ETF	143.73	143.76	143.7	143.76	13900.0
2007-04-03 04:00:00	QQQ	ETF	43.72	43.72	43.72	43.72	600.0
2007-04-03 05:00:00	QQQ	ETF	43.75	43.79	43.75	43.79	36414.0
2007-04-03 07:00:00	QQQ	ETF	43.73	43.83	43.71	43.81	293921.0
2007-04-03 08:00:00	QQQ	ETF	43.81	43.86	43.8	43.82	602346.0
2007-04-03 09:00:00	QQQ	ETF	43.82	43.94	43.79	43.92	16680216.0
2007-04-03 10:00:00	QQQ	ETF	43.92	44.31	43.92	44.25	28409600.0
2007-04-03 11:00:00	QQQ	ETF	44.25	44.31	44.16	44.28	10037900.0
2007-04-03 12:00:00	QQQ	ETF	44.28	44.29	44.21	44.22	4086500.0
2007-04-03 13:00:00	QQQ	ETF	44.22	44.3	44.2	44.22	12245700.0
2007-04-03 14:00:00	QQQ	ETF	44.22	44.26	44.16	44.2	12457600.0
2007-04-03 15:00:00	QQQ	ETF	44.2	44.25	44.13	44.17	13831000.0
2007-04-03 16:00:00	QQQ	ETF	44.17	44.24	44.14	44.2	4154584.0
2007-04-03 17:00:00	QQQ	ETF	44.21	44.23	44.17	44.17	44419.0
2007-04-03 18:00:00	QQQ	ETF	44.18	44.21	44.18	44.21	23570.0
2007-04-03 19:00:00	QQQ	ETF	44.21	44.23	44.19	44.19	16400.0
2007-04-03 07:00:00	IWM	ETF	79.99	80.04	79.99	80.04	3200.0
2007-04-03 08:00:00	IWM	ETF	80.01	80.15	79.83	80.1	381800.0
2007-04-03 09:00:00	IWM	ETF	80.08	80.26	80.0	80.19	6941442.0
2007-04-03 10:00:00	IWM	ETF	80.19	80.76	80.19	80.64	12777051.0
2007-04-03 11:00:00	IWM	ETF	80.63	80.75	80.51	80.66	6582720.0
2007-04-03 12:00:00	IWM	ETF	80.66	80.67	80.56	80.56	2648666.0
2007-04-03 13:00:00	IWM	ETF	80.56	80.77	80.53	80.66	3923800.0
2007-04-03 14:00:00	IWM	ETF	80.66	80.7	80.5	80.63	3767200.0
2007-04-03 15:00:00	IWM	ETF	80.625	80.65	80.51	80.58	5454882.0
2007-04-03 16:00:00	IWM	ETF	80.57	80.65	80.5	80.53	869100.0
2007-04-03 17:00:00	IWM	ETF	80.54	80.54	80.49	80.49	1200.0
2007-04-03 18:00:00	IWM	ETF	80.51	80.52	80.51	80.52	800.0
2007-04-03 07:00:00	DIA	ETF	123.95	124.13	123.95	124.13	17300.0
2007-04-03 08:00:00	DIA	ETF	124.19	124.3	124.15	124.21	28600.0
2007-04-03 09:00:00	DIA	ETF	124.25	124.45	124.18	124.33	677600.0
2007-04-03 10:00:00	DIA	ETF	124.35	125.06	124.35	125.0	2111100.0
2007-04-03 11:00:00	DIA	ETF	124.99	125.01	124.82	124.97	528500.0
2007-04-03 12:00:00	DIA	ETF	124.96	124.99	124.87	124.9	179000.0
2007-04-03 13:00:00	DIA	ETF	124.9	125.26	124.83	125.14	1231100.0
2007-04-03 14:00:00	DIA	ETF	125.14	125.2	124.97	124.99	1042700.0

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

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