PREVIEW / etf_1hour / 2006-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-16.parquet
  size:    45 KB
  rows:    1,423

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-16 04:00:00	SPY	ETF	125.42	125.42	125.42	125.42	100.0
2006-06-16 05:00:00	SPY	ETF	125.32	125.35	125.32	125.35	20100.0
2006-06-16 06:00:00	SPY	ETF	125.37	125.45	125.37	125.45	9800.0
2006-06-16 07:00:00	SPY	ETF	125.47	125.47	125.31	125.39	205200.0
2006-06-16 08:00:00	SPY	ETF	125.39	126.12	125.12	125.13	6304500.0
2006-06-16 09:00:00	SPY	ETF	125.14	126.048	125.06	125.41	15542900.0
2006-06-16 10:00:00	SPY	ETF	125.4	125.42	124.78	124.868	15179700.0
2006-06-16 11:00:00	SPY	ETF	124.88	125.48	124.57	124.85	11547100.0
2006-06-16 12:00:00	SPY	ETF	124.85	125.14	124.46	124.78	13446200.0
2006-06-16 13:00:00	SPY	ETF	124.78	124.93	124.68	124.83	3725600.0
2006-06-16 14:00:00	SPY	ETF	124.83	125.15	124.71	125.03	5832800.0
2006-06-16 15:00:00	SPY	ETF	125.03	125.4	124.95	124.97	16675200.0
2006-06-16 16:00:00	SPY	ETF	124.99	125.03	124.65	124.84	2186200.0
2006-06-16 17:00:00	SPY	ETF	124.83	124.85	124.353	124.85	1010500.0
2006-06-16 18:00:00	SPY	ETF	124.81	124.81	124.48	124.48	11900.0
2006-06-16 19:00:00	SPY	ETF	124.65	124.8	124.65	124.8	2100.0
2006-06-16 09:00:00	QQQ	ETF	38.53	38.68	38.43	38.62	19629200.0
2006-06-16 10:00:00	QQQ	ETF	38.63	38.65	38.27	38.31	24333000.0
2006-06-16 11:00:00	QQQ	ETF	38.3	38.44	38.23	38.33	13475300.0
2006-06-16 12:00:00	QQQ	ETF	38.34	38.44	38.2	38.32	12122900.0
2006-06-16 13:00:00	QQQ	ETF	38.32	38.43	38.29	38.37	7506200.0
2006-06-16 14:00:00	QQQ	ETF	38.37	38.5	38.34	38.45	8869300.0
2006-06-16 15:00:00	QQQ	ETF	38.45	38.59	38.37	38.37	21215600.0
2006-06-16 07:00:00	IWM	ETF	69.65	69.65	69.65	69.65	500.0
2006-06-16 08:00:00	IWM	ETF	69.63	69.7	69.31	69.33	285400.0
2006-06-16 09:00:00	IWM	ETF	69.31	69.7	69.25	69.61	11103500.0
2006-06-16 10:00:00	IWM	ETF	69.62	69.63	68.57	68.66	13780500.0
2006-06-16 11:00:00	IWM	ETF	68.65	69.65	68.62	69.04	7655200.0
2006-06-16 12:00:00	IWM	ETF	69.05	69.41	68.71	68.94	7752300.0
2006-06-16 13:00:00	IWM	ETF	68.95	69.1	68.83	69.03	4716400.0
2006-06-16 14:00:00	IWM	ETF	69.03	69.09	68.76	68.98	6098900.0
2006-06-16 15:00:00	IWM	ETF	68.99	69.65	68.75	68.84	9382900.0
2006-06-16 16:00:00	IWM	ETF	68.83	69.15	68.7	68.84	3844000.0
2006-06-16 17:00:00	IWM	ETF	68.7	68.7	68.6	68.6	5700.0
2006-06-16 07:00:00	DIA	ETF	109.98	109.98	109.93	109.93	1500.0
2006-06-16 08:00:00	DIA	ETF	110.02	110.02	109.77	109.77	29700.0
2006-06-16 09:00:00	DIA	ETF	109.77	110.18	109.75	110.13	1053400.0
2006-06-16 10:00:00	DIA	ETF	110.12	110.17	109.81	109.89	949900.0
2006-06-16 11:00:00	DIA	ETF	109.9	110.09	109.71	109.91	882100.0
2006-06-16 12:00:00	DIA	ETF	109.92	110.14	109.73	109.98	617300.0
2006-06-16 13:00:00	DIA	ETF	109.98	110.06	109.86	110.0	361900.0
2006-06-16 14:00:00	DIA	ETF	109.98	110.22	109.9	110.13	444900.0
2006-06-16 15:00:00	DIA	ETF	110.14	110.38	110.0	110.09	1050200.0
2006-06-16 16:00:00	DIA	ETF	110.09	110.09	109.92	109.99	153500.0
2006-06-16 18:00:00	DIA	ETF	109.98	109.98	109.98	109.98	900.0
2006-06-16 06:00:00	GLD	ETF	58.0	58.0	58.0	58.0	3000.0
2006-06-16 07:00:00	GLD	ETF	57.86	57.9	57.7	57.7	143500.0
2006-06-16 08:00:00	GLD	ETF	57.7	57.9	57.01	57.3	569300.0
2006-06-16 09:00:00	GLD	ETF	57.3	57.42	56.92	57.14	1706100.0
2006-06-16 10:00:00	GLD	ETF	57.14	57.27	56.93	56.99	981200.0

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

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