PREVIEW / etf_1hour / 2006-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-28.parquet
  size:    52 KB
  rows:    1,662

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-09-28 04:00:00	SPY	ETF	133.79	133.79	133.79	133.79	200.0
2006-09-28 06:00:00	SPY	ETF	133.89	133.89	133.89	133.89	300.0
2006-09-28 07:00:00	SPY	ETF	133.89	133.92	133.83	133.87	24100.0
2006-09-28 08:00:00	SPY	ETF	133.85	133.87	133.52	133.75	916000.0
2006-09-28 09:00:00	SPY	ETF	133.76	133.97	133.5	133.57	8199300.0
2006-09-28 10:00:00	SPY	ETF	133.58	133.94	133.4	133.51	10619300.0
2006-09-28 11:00:00	SPY	ETF	133.5	133.95	133.45	133.49	8244400.0
2006-09-28 12:00:00	SPY	ETF	133.48	133.53	133.28	133.47	9280100.0
2006-09-28 13:00:00	SPY	ETF	133.48	133.8	133.45	133.75	5194500.0
2006-09-28 14:00:00	SPY	ETF	133.73	133.93	133.69	133.83	6233300.0
2006-09-28 15:00:00	SPY	ETF	133.82	133.99	133.66	133.78	7825900.0
2006-09-28 16:00:00	SPY	ETF	133.77	133.85	133.66	133.69	722200.0
2006-09-28 17:00:00	SPY	ETF	133.67	133.75	133.65	133.73	62300.0
2006-09-28 18:00:00	SPY	ETF	133.72	133.72	133.71	133.71	3100.0
2006-09-28 19:00:00	SPY	ETF	133.75	133.75	133.7	133.7	2000.0
2006-09-28 09:00:00	QQQ	ETF	40.77	40.89	40.63	40.74	13370300.0
2006-09-28 10:00:00	QQQ	ETF	40.74	40.8	40.54	40.62	16875200.0
2006-09-28 11:00:00	QQQ	ETF	40.63	40.73	40.51	40.53	12212300.0
2006-09-28 12:00:00	QQQ	ETF	40.52	40.62	40.43	40.59	10078600.0
2006-09-28 13:00:00	QQQ	ETF	40.6	40.76	40.57	40.72	8364400.0
2006-09-28 14:00:00	QQQ	ETF	40.71	40.8	40.67	40.74	7242000.0
2006-09-28 15:00:00	QQQ	ETF	40.73	40.85	40.68	40.83	10205100.0
2006-09-28 07:00:00	IWM	ETF	73.0	73.0	73.0	73.0	1400.0
2006-09-28 08:00:00	IWM	ETF	73.03	73.15	72.92	72.99	1420100.0
2006-09-28 09:00:00	IWM	ETF	72.99	73.28	72.74	72.86	4903100.0
2006-09-28 10:00:00	IWM	ETF	72.86	73.03	72.49	72.61	5515400.0
2006-09-28 11:00:00	IWM	ETF	72.61	72.73	72.43	72.45	4562100.0
2006-09-28 12:00:00	IWM	ETF	72.43	72.45	72.25	72.34	2281600.0
2006-09-28 13:00:00	IWM	ETF	72.33	72.76	72.3	72.71	4702500.0
2006-09-28 14:00:00	IWM	ETF	72.71	72.94	72.66	72.78	5401000.0
2006-09-28 15:00:00	IWM	ETF	72.78	72.93	72.67	72.74	5851600.0
2006-09-28 16:00:00	IWM	ETF	72.73	72.76	72.63	72.71	149800.0
2006-09-28 17:00:00	IWM	ETF	72.68	72.77	72.68	72.77	3900.0
2006-09-28 08:00:00	DIA	ETF	117.0	117.02	116.9	116.9	115400.0
2006-09-28 09:00:00	DIA	ETF	116.93	117.15	116.78	116.92	3809100.0
2006-09-28 10:00:00	DIA	ETF	116.89	117.05	116.69	116.74	1520800.0
2006-09-28 11:00:00	DIA	ETF	116.74	116.9	116.6	116.6	2164200.0
2006-09-28 12:00:00	DIA	ETF	116.6	116.76	116.5	116.7	679700.0
2006-09-28 13:00:00	DIA	ETF	116.68	116.94	116.66	116.9	934100.0
2006-09-28 14:00:00	DIA	ETF	116.9	117.1	116.86	117.02	1138800.0
2006-09-28 15:00:00	DIA	ETF	117.0	117.18	116.86	117.02	1357400.0
2006-09-28 16:00:00	DIA	ETF	117.0025	117.03	116.9	116.9	27000.0
2006-09-28 17:00:00	DIA	ETF	116.95	116.95	116.95	116.95	2500.0
2006-09-28 18:00:00	DIA	ETF	117.0	117.0	117.0	117.0	400.0
2006-09-28 19:00:00	DIA	ETF	116.97	116.97	116.97	116.97	300.0
2006-09-28 08:00:00	GLD	ETF	59.87	59.97	59.65	59.8	96500.0
2006-09-28 09:00:00	GLD	ETF	59.86	60.02	59.81	59.96	833100.0
2006-09-28 10:00:00	GLD	ETF	59.96	59.97	59.57	59.89	692700.0
2006-09-28 11:00:00	GLD	ETF	59.89	60.27	59.89	60.18	1023500.0
2006-09-28 12:00:00	GLD	ETF	60.19	60.21	59.83	59.89	389400.0

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

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