PREVIEW / etf_1hour / 2006-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-18.parquet
  size:    50 KB
  rows:    1,566

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
2006-07-18 04:00:00	SPY	ETF	123.04	123.04	123.04	123.04	2000.0
2006-07-18 05:00:00	SPY	ETF	123.2	123.2	123.2	123.2	2000.0
2006-07-18 06:00:00	SPY	ETF	123.1	123.1	123.1	123.1	400.0
2006-07-18 07:00:00	SPY	ETF	123.1	123.43	123.08	123.33	135100.0
2006-07-18 08:00:00	SPY	ETF	123.12	123.62	123.08	123.57	4242900.0
2006-07-18 09:00:00	SPY	ETF	123.56	124.05	123.53	123.93	13105700.0
2006-07-18 10:00:00	SPY	ETF	123.92	123.93	123.11	123.15	15880400.0
2006-07-18 11:00:00	SPY	ETF	123.15	123.43	122.94	123.29	13947000.0
2006-07-18 12:00:00	SPY	ETF	123.29	123.49	123.01	123.12	9759000.0
2006-07-18 13:00:00	SPY	ETF	123.13	123.14	122.48	122.59	16759800.0
2006-07-18 14:00:00	SPY	ETF	122.58	123.52	122.39	123.29	21182700.0
2006-07-18 15:00:00	SPY	ETF	123.3	123.89	122.77	123.68	20829800.0
2006-07-18 16:00:00	SPY	ETF	123.66	124.02	123.63	123.92	3135800.0
2006-07-18 17:00:00	SPY	ETF	123.93	123.93	123.79	123.82	1469400.0
2006-07-18 18:00:00	SPY	ETF	123.87	123.94	123.82	123.82	34300.0
2006-07-18 19:00:00	SPY	ETF	123.84	123.87	123.82	123.84	9300.0
2006-07-18 09:00:00	QQQ	ETF	36.22	36.33	36.16	36.24	23738900.0
2006-07-18 10:00:00	QQQ	ETF	36.24	36.25	35.86	35.89	29347300.0
2006-07-18 11:00:00	QQQ	ETF	35.88	35.99	35.78	35.91	18628600.0
2006-07-18 12:00:00	QQQ	ETF	35.92	36.07	35.8	35.84	15764600.0
2006-07-18 13:00:00	QQQ	ETF	35.84	36.03	35.54	35.63	33495700.0
2006-07-18 14:00:00	QQQ	ETF	35.63	35.98	35.61	35.89	38496200.0
2006-07-18 15:00:00	QQQ	ETF	35.9	36.22	35.72	36.14	32329800.0
2006-07-18 07:00:00	IWM	ETF	67.44	67.48	67.44	67.48	20000.0
2006-07-18 08:00:00	IWM	ETF	67.5	67.77	67.44	67.73	2840200.0
2006-07-18 09:00:00	IWM	ETF	67.71	68.25	67.7	68.0	9482100.0
2006-07-18 10:00:00	IWM	ETF	68.0	68.0	67.22	67.26	9810100.0
2006-07-18 11:00:00	IWM	ETF	67.25	67.4	67.0	67.24	5904800.0
2006-07-18 12:00:00	IWM	ETF	67.24	67.48	66.98	67.13	7167300.0
2006-07-18 13:00:00	IWM	ETF	67.12	67.12	66.62	66.74	10205500.0
2006-07-18 14:00:00	IWM	ETF	66.74	67.63	66.7	67.4	11550200.0
2006-07-18 15:00:00	IWM	ETF	67.4	67.87	67.09	67.76	13643700.0
2006-07-18 16:00:00	IWM	ETF	67.77	68.49	67.75	67.85	1797300.0
2006-07-18 17:00:00	IWM	ETF	67.84	67.86	67.8	67.8	283400.0
2006-07-18 18:00:00	IWM	ETF	67.84	67.86	67.77	67.77	23500.0
2006-07-18 19:00:00	IWM	ETF	67.77	67.77	67.77	67.77	3400.0
2006-07-18 07:00:00	DIA	ETF	107.48	107.48	107.48	107.48	100.0
2006-07-18 08:00:00	DIA	ETF	107.6	107.62	107.44	107.6	827200.0
2006-07-18 09:00:00	DIA	ETF	107.68	108.18	107.66	108.0	1694600.0
2006-07-18 10:00:00	DIA	ETF	108.0	108.01	107.35	107.37	1561400.0
2006-07-18 11:00:00	DIA	ETF	107.37	107.57	107.2	107.5	800700.0
2006-07-18 12:00:00	DIA	ETF	107.47	107.62	107.21	107.33	438600.0
2006-07-18 13:00:00	DIA	ETF	107.31	107.31	106.89	107.01	1926500.0
2006-07-18 14:00:00	DIA	ETF	107.04	107.84	107.0	107.71	2301700.0
2006-07-18 15:00:00	DIA	ETF	107.7	108.16	107.29	108.02	1515000.0
2006-07-18 16:00:00	DIA	ETF	108.04	108.32	108.0	108.22	123300.0
2006-07-18 17:00:00	DIA	ETF	108.25	108.25	108.1	108.22	4400.0
2006-07-18 18:00:00	DIA	ETF	108.13	108.13	108.1	108.1	1200.0
2006-07-18 06:00:00	GLD	ETF	64.0	64.0	64.0	64.0	200.0
2006-07-18 07:00:00	GLD	ETF	64.5	64.57	64.5	64.57	4600.0

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

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