PREVIEW / etf_1hour / 2006-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-15.parquet
  size:    46 KB
  rows:    1,402

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-15 04:00:00	SPY	ETF	123.83	124.0	123.83	124.0	3000.0
2006-06-15 05:00:00	SPY	ETF	124.07	124.15	124.07	124.15	3100.0
2006-06-15 06:00:00	SPY	ETF	124.12	124.12	123.99	124.1	3800.0
2006-06-15 07:00:00	SPY	ETF	124.03	124.1	123.99	124.08	243600.0
2006-06-15 08:00:00	SPY	ETF	124.1	124.16	123.76	123.92	5697500.0
2006-06-15 09:00:00	SPY	ETF	123.91	124.38	123.86	124.32	15092500.0
2006-06-15 10:00:00	SPY	ETF	124.32	124.84	124.14	124.68	19564100.0
2006-06-15 11:00:00	SPY	ETF	124.69	124.88	124.32	124.72	9002200.0
2006-06-15 12:00:00	SPY	ETF	124.7	124.76	124.55	124.61	10671000.0
2006-06-15 13:00:00	SPY	ETF	124.6	124.8	124.31	124.8	11572600.0
2006-06-15 14:00:00	SPY	ETF	124.78	125.73	124.78	125.65	21924400.0
2006-06-15 15:00:00	SPY	ETF	125.66	126.36	124.09	126.0	28123800.0
2006-06-15 16:00:00	SPY	ETF	126.0	126.26	124.8133	126.06	5512800.0
2006-06-15 17:00:00	SPY	ETF	126.05	126.16	125.9	125.9	409300.0
2006-06-15 18:00:00	SPY	ETF	125.9	126.08	125.68	126.06	350100.0
2006-06-15 19:00:00	SPY	ETF	126.01	126.09	125.98	126.09	13600.0
2006-06-15 09:00:00	QQQ	ETF	37.84	38.0	37.8	37.98	24237900.0
2006-06-15 10:00:00	QQQ	ETF	37.97	38.24	37.91	38.17	37014300.0
2006-06-15 11:00:00	QQQ	ETF	38.17	38.28	38.06	38.19	18239700.0
2006-06-15 12:00:00	QQQ	ETF	38.18	38.19	38.1	38.13	9448200.0
2006-06-15 13:00:00	QQQ	ETF	38.14	38.26	38.02	38.24	13084400.0
2006-06-15 14:00:00	QQQ	ETF	38.25	38.6	38.22	38.56	33824600.0
2006-06-15 15:00:00	QQQ	ETF	38.56	38.79	38.36	38.66	40234100.0
2006-06-15 07:00:00	IWM	ETF	67.9	68.09	67.85	67.9	18700.0
2006-06-15 08:00:00	IWM	ETF	68.0	68.21	67.9	68.04	2474500.0
2006-06-15 09:00:00	IWM	ETF	68.04	68.69	67.91	68.69	16372500.0
2006-06-15 10:00:00	IWM	ETF	68.68	69.23	68.48	69.04	17262400.0
2006-06-15 11:00:00	IWM	ETF	69.05	69.17	68.83	69.08	11266700.0
2006-06-15 12:00:00	IWM	ETF	69.08	69.13	68.91	68.96	4535400.0
2006-06-15 13:00:00	IWM	ETF	68.96	69.15	68.76	69.15	4790900.0
2006-06-15 14:00:00	IWM	ETF	69.15	69.66	69.15	69.63	14851400.0
2006-06-15 15:00:00	IWM	ETF	69.64	69.97	69.4	69.82	21619700.0
2006-06-15 16:00:00	IWM	ETF	69.82	69.84	69.4	69.81	1251600.0
2006-06-15 17:00:00	IWM	ETF	69.81	69.85	69.76	69.8	194100.0
2006-06-15 18:00:00	IWM	ETF	69.8	69.84	69.8	69.84	5000.0
2006-06-15 19:00:00	IWM	ETF	69.8	69.81	69.8	69.81	400.0
2006-06-15 04:00:00	DIA	ETF	108.56	108.56	108.56	108.56	100.0
2006-06-15 07:00:00	DIA	ETF	108.66	108.75	108.66	108.75	600.0
2006-06-15 08:00:00	DIA	ETF	108.75	108.75	108.42	108.51	73600.0
2006-06-15 09:00:00	DIA	ETF	108.55	108.98	108.46	108.9125	1724500.0
2006-06-15 10:00:00	DIA	ETF	108.91	109.3	108.79	109.2	1951700.0
2006-06-15 11:00:00	DIA	ETF	109.2	109.35	108.91	109.16	1147700.0
2006-06-15 12:00:00	DIA	ETF	109.16	109.19	109.03	109.05	420100.0
2006-06-15 13:00:00	DIA	ETF	109.05	109.21	108.79	109.17	932300.0
2006-06-15 14:00:00	DIA	ETF	109.18	110.02	109.16	109.89	2175100.0
2006-06-15 15:00:00	DIA	ETF	109.9	110.46	109.78	110.15	2518800.0
2006-06-15 16:00:00	DIA	ETF	110.1	110.36	110.09	110.25	108900.0
2006-06-15 04:00:00	GLD	ETF	56.5	56.7	56.5	56.7	700.0
2006-06-15 06:00:00	GLD	ETF	56.7	56.85	56.5	56.51	3000.0
2006-06-15 07:00:00	GLD	ETF	56.52	57.0	56.52	57.0	124400.0

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

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