PREVIEW / etf_1hour / 2006-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-27.parquet
  size:    48 KB
  rows:    1,480

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-06-27 07:00:00	SPY	ETF	124.74	124.74	124.59	124.7	146200.0
2006-06-27 08:00:00	SPY	ETF	124.75	124.91	124.6	124.87	960800.0
2006-06-27 09:00:00	SPY	ETF	124.87	125.26	124.87	125.16	6338200.0
2006-06-27 10:00:00	SPY	ETF	125.17	125.29	124.83	124.89	8822200.0
2006-06-27 11:00:00	SPY	ETF	124.9	124.92	124.32	124.52	13694200.0
2006-06-27 12:00:00	SPY	ETF	124.51	124.53	124.13	124.28	7844100.0
2006-06-27 13:00:00	SPY	ETF	124.28	124.44	124.17	124.33	5062200.0
2006-06-27 14:00:00	SPY	ETF	124.33	124.47	123.83	124.0	10296500.0
2006-06-27 15:00:00	SPY	ETF	123.9905	124.35	123.77	123.87	13161600.0
2006-06-27 16:00:00	SPY	ETF	123.88	124.518	123.78	123.95	1040800.0
2006-06-27 17:00:00	SPY	ETF	123.83	123.96	123.83	123.96	142400.0
2006-06-27 18:00:00	SPY	ETF	123.94	124.0	123.92	123.98	3300.0
2006-06-27 19:00:00	SPY	ETF	123.98	123.99	123.98	123.99	53200.0
2006-06-27 09:00:00	QQQ	ETF	38.28	38.33	38.19	38.27	7875900.0
2006-06-27 10:00:00	QQQ	ETF	38.26	38.32	37.91	37.95	20250800.0
2006-06-27 11:00:00	QQQ	ETF	37.95	37.96	37.68	37.79	21226600.0
2006-06-27 12:00:00	QQQ	ETF	37.8	37.81	37.61	37.66	10269800.0
2006-06-27 13:00:00	QQQ	ETF	37.65	37.77	37.63	37.72	9478900.0
2006-06-27 14:00:00	QQQ	ETF	37.72	37.77	37.5	37.55	19710000.0
2006-06-27 15:00:00	QQQ	ETF	37.55	37.76	37.49	37.53	22744600.0
2006-06-27 08:00:00	IWM	ETF	69.37	69.47	69.36	69.45	96600.0
2006-06-27 09:00:00	IWM	ETF	69.51	69.79	69.39	69.69	4401300.0
2006-06-27 10:00:00	IWM	ETF	69.7	69.83	69.33	69.33	7753400.0
2006-06-27 11:00:00	IWM	ETF	69.3325	69.37	69.07	69.19	13388800.0
2006-06-27 12:00:00	IWM	ETF	69.19	69.19	68.54	68.67	8864900.0
2006-06-27 13:00:00	IWM	ETF	68.68	68.87	68.58	68.74	4234800.0
2006-06-27 14:00:00	IWM	ETF	68.75	68.9	68.2	68.2504	7579800.0
2006-06-27 15:00:00	IWM	ETF	68.26	68.56	68.02	68.2	13935100.0
2006-06-27 16:00:00	IWM	ETF	68.21	68.37	68.06	68.35	598700.0
2006-06-27 17:00:00	IWM	ETF	68.29	68.3	68.29	68.3	1700.0
2006-06-27 18:00:00	IWM	ETF	68.3	68.3	68.26	68.27	6200.0
2006-06-27 08:00:00	DIA	ETF	110.17	110.31	110.1	110.29	17500.0
2006-06-27 09:00:00	DIA	ETF	110.36	110.59	110.32	110.46	366000.0
2006-06-27 10:00:00	DIA	ETF	110.45	110.52	110.06	110.1005	1114800.0
2006-06-27 11:00:00	DIA	ETF	110.11	110.12	109.52	109.65	1500500.0
2006-06-27 12:00:00	DIA	ETF	109.62	109.63	109.37	109.57	526200.0
2006-06-27 13:00:00	DIA	ETF	109.57	109.64	109.47	109.57	395200.0
2006-06-27 14:00:00	DIA	ETF	109.55	109.66	109.16	109.3	1594000.0
2006-06-27 15:00:00	DIA	ETF	109.2905	109.55	109.14	109.16	858200.0
2006-06-27 16:00:00	DIA	ETF	109.14	109.29	109.14	109.26	24900.0
2006-06-27 17:00:00	DIA	ETF	109.29	109.29	109.26	109.26	1600.0
2006-06-27 18:00:00	DIA	ETF	109.3	109.3	109.3	109.3	100.0
2006-06-27 19:00:00	DIA	ETF	109.24	109.24	109.24	109.24	400.0
2006-06-27 07:00:00	GLD	ETF	58.4	58.4	58.34	58.34	3500.0
2006-06-27 08:00:00	GLD	ETF	58.34	58.76	58.26	58.57	108500.0
2006-06-27 09:00:00	GLD	ETF	58.62	58.85	58.58	58.61	514200.0
2006-06-27 10:00:00	GLD	ETF	58.6	59.26	58.54	59.05	2023400.0
2006-06-27 11:00:00	GLD	ETF	59.05	59.21	58.65	58.6695	855100.0
2006-06-27 12:00:00	GLD	ETF	58.66	58.66	57.84	57.97	1147200.0
2006-06-27 13:00:00	GLD	ETF	57.96	58.28	57.81	57.97	661500.0

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

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