PREVIEW / etf_1hour / 2006-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-02.parquet
  size:    40 KB
  rows:    1,210

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-02-02 05:00:00	SPY	ETF	128.05	128.05	128.02	128.02	1900.0
2006-02-02 07:00:00	SPY	ETF	128.0	128.0	127.93	127.97	56300.0
2006-02-02 08:00:00	SPY	ETF	127.94	128.4	127.93	128.02	1598500.0
2006-02-02 09:00:00	SPY	ETF	128.03	128.14	127.89	128.02	5753300.0
2006-02-02 10:00:00	SPY	ETF	128.0	128.1	127.5	127.53	14380300.0
2006-02-02 11:00:00	SPY	ETF	127.53	127.58	126.8	127.11	20948500.0
2006-02-02 12:00:00	SPY	ETF	127.11	127.42	127.01	127.16	9309900.0
2006-02-02 13:00:00	SPY	ETF	127.15	127.23	126.83	127.1	8092100.0
2006-02-02 14:00:00	SPY	ETF	127.11	127.27	126.92	126.97	5350800.0
2006-02-02 15:00:00	SPY	ETF	126.97	127.28	126.82	127.11	8623900.0
2006-02-02 16:00:00	SPY	ETF	127.11	127.16	126.84	126.88	3495100.0
2006-02-02 17:00:00	SPY	ETF	126.89	126.95	126.87	126.95	4800.0
2006-02-02 18:00:00	SPY	ETF	126.9	126.9	126.88	126.9	1400.0
2006-02-02 09:00:00	QQQ	ETF	42.01	42.08	41.05	41.96	8127900.0
2006-02-02 10:00:00	QQQ	ETF	41.96	41.99	41.62	41.66	17963300.0
2006-02-02 11:00:00	QQQ	ETF	41.66	41.67	41.44	41.54	17854500.0
2006-02-02 12:00:00	QQQ	ETF	41.53	41.8	41.48	41.54	9561100.0
2006-02-02 13:00:00	QQQ	ETF	41.53	41.62	41.47	41.59	6550000.0
2006-02-02 14:00:00	QQQ	ETF	41.59	41.62	41.49	41.49	8233600.0
2006-02-02 15:00:00	QQQ	ETF	41.49	41.6	41.41	41.44	14440900.0
2006-02-02 07:00:00	IWM	ETF	72.87	72.87	72.87	72.87	2000.0
2006-02-02 08:00:00	IWM	ETF	72.98	73.09	72.9	72.9	18200.0
2006-02-02 09:00:00	IWM	ETF	72.94	73.09	72.84	73.02	4268200.0
2006-02-02 10:00:00	IWM	ETF	73.02	73.05	72.26	72.28	9082300.0
2006-02-02 11:00:00	IWM	ETF	72.28	72.28	71.66	71.89	14586400.0
2006-02-02 12:00:00	IWM	ETF	71.9	72.24	71.8	72.15	3923100.0
2006-02-02 13:00:00	IWM	ETF	72.15	72.21	71.83	72.03	2878000.0
2006-02-02 14:00:00	IWM	ETF	72.03	72.09	71.82	71.94	3196800.0
2006-02-02 15:00:00	IWM	ETF	71.94	72.2	71.8	72.12	6471500.0
2006-02-02 16:00:00	IWM	ETF	72.13	72.18	71.7	72.01	1132000.0
2006-02-02 17:00:00	IWM	ETF	72.05	72.05	72.04	72.04	1000.0
2006-02-02 18:00:00	IWM	ETF	72.0	72.0	72.0	72.0	5500000.0
2006-02-02 07:00:00	DIA	ETF	109.27	109.28	109.25	109.28	1600.0
2006-02-02 08:00:00	DIA	ETF	109.25	109.36	109.25	109.28	6800.0
2006-02-02 09:00:00	DIA	ETF	109.33	109.39	109.16	109.28	643200.0
2006-02-02 10:00:00	DIA	ETF	109.26	109.37	108.9	108.97	1021500.0
2006-02-02 11:00:00	DIA	ETF	108.95	108.95	108.19	108.42	3307700.0
2006-02-02 12:00:00	DIA	ETF	108.38	108.74	108.38	108.53	659600.0
2006-02-02 13:00:00	DIA	ETF	108.53	108.64	108.32	108.51	423000.0
2006-02-02 14:00:00	DIA	ETF	108.49	108.6	108.33	108.39	460300.0
2006-02-02 15:00:00	DIA	ETF	108.38	108.59	108.27	108.48	734500.0
2006-02-02 16:00:00	DIA	ETF	108.5	108.51	108.29	108.32	37300.0
2006-02-02 17:00:00	DIA	ETF	108.32	108.32	108.3	108.3	2000.0
2006-02-02 18:00:00	DIA	ETF	108.45	108.45	108.45	108.45	100.0
2006-02-02 07:00:00	GLD	ETF	56.92	56.92	56.92	56.92	1000.0
2006-02-02 08:00:00	GLD	ETF	56.99	57.15	56.92	56.95	11000.0
2006-02-02 09:00:00	GLD	ETF	57.0	57.05	56.8	57.0	635100.0
2006-02-02 10:00:00	GLD	ETF	56.99	57.3	56.98	57.05	919600.0
2006-02-02 11:00:00	GLD	ETF	57.05	57.12	56.77	56.78	1174200.0
2006-02-02 12:00:00	GLD	ETF	56.77	57.04	56.67	56.92	770600.0

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

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