PREVIEW / etf_1hour / 2006-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-27.parquet
  size:    42 KB
  rows:    1,270

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-04-27 06:00:00	SPY	ETF	130.28	130.28	129.88	129.93	6100.0
2006-04-27 07:00:00	SPY	ETF	129.93	129.98	129.86	129.92	162100.0
2006-04-27 08:00:00	SPY	ETF	129.92	130.01	129.75	129.86	1871400.0
2006-04-27 09:00:00	SPY	ETF	129.85	129.99	129.59	129.85	6800200.0
2006-04-27 10:00:00	SPY	ETF	129.84	131.1	129.84	130.66	45269200.0
2006-04-27 11:00:00	SPY	ETF	130.66	131.44	130.58	131.15	24992000.0
2006-04-27 12:00:00	SPY	ETF	131.14	131.63	131.09	131.48	9271300.0
2006-04-27 13:00:00	SPY	ETF	131.48	131.48	130.8	131.15	7834100.0
2006-04-27 14:00:00	SPY	ETF	131.15	131.47	130.95	131.32	9028500.0
2006-04-27 15:00:00	SPY	ETF	131.33	131.43	130.96	131.01	12823200.0
2006-04-27 16:00:00	SPY	ETF	131.0	131.1	130.83	130.95	1429300.0
2006-04-27 17:00:00	SPY	ETF	130.9	130.97	130.29	130.86	181400.0
2006-04-27 18:00:00	SPY	ETF	130.86	130.9	130.81	130.9	118800.0
2006-04-27 19:00:00	SPY	ETF	130.87	130.93	130.85	130.9	2200.0
2006-04-27 09:00:00	QQQ	ETF	41.67	41.77	41.5	41.74	14753600.0
2006-04-27 10:00:00	QQQ	ETF	41.74	42.12	41.7	41.96	52239600.0
2006-04-27 11:00:00	QQQ	ETF	41.97	42.39	41.92	42.31	31055800.0
2006-04-27 12:00:00	QQQ	ETF	42.32	42.49	42.3	42.41	19598900.0
2006-04-27 13:00:00	QQQ	ETF	42.41	42.42	42.24	42.3	17064100.0
2006-04-27 14:00:00	QQQ	ETF	42.3	42.46	42.21	42.39	12072800.0
2006-04-27 15:00:00	QQQ	ETF	42.39	42.43	42.19	42.26	16416200.0
2006-04-27 08:00:00	IWM	ETF	75.57	75.63	75.49	75.55	165000.0
2006-04-27 09:00:00	IWM	ETF	75.54	75.58	74.89	75.15	6731300.0
2006-04-27 10:00:00	IWM	ETF	75.15	76.16	75.0	75.49	23799900.0
2006-04-27 11:00:00	IWM	ETF	75.5	76.39	75.45	76.03	12232500.0
2006-04-27 12:00:00	IWM	ETF	76.05	76.67	76.05	76.51	14658900.0
2006-04-27 13:00:00	IWM	ETF	76.51	76.54	76.01	76.06	5723200.0
2006-04-27 14:00:00	IWM	ETF	76.05	76.29	75.71	76.1	13201000.0
2006-04-27 15:00:00	IWM	ETF	76.1	76.17	75.52	75.55	14717400.0
2006-04-27 16:00:00	IWM	ETF	75.51	75.59	75.35	75.35	219100.0
2006-04-27 17:00:00	IWM	ETF	75.35	75.5	75.33	75.5	39500.0
2006-04-27 18:00:00	IWM	ETF	75.41	75.41	75.36	75.36	125800.0
2006-04-27 07:00:00	DIA	ETF	112.93	112.93	112.93	112.93	100.0
2006-04-27 08:00:00	DIA	ETF	112.92	112.98	112.82	112.9	22700.0
2006-04-27 09:00:00	DIA	ETF	112.88	112.97	112.68	112.9	1103000.0
2006-04-27 10:00:00	DIA	ETF	112.88	113.77	112.88	113.37	3329500.0
2006-04-27 11:00:00	DIA	ETF	113.36	113.89	113.31	113.76	2063000.0
2006-04-27 12:00:00	DIA	ETF	113.76	114.1	113.76	113.9875	689100.0
2006-04-27 13:00:00	DIA	ETF	113.983	113.983	113.68	113.75	2308800.0
2006-04-27 14:00:00	DIA	ETF	113.76	114.09	113.61	113.93	3963100.0
2006-04-27 15:00:00	DIA	ETF	113.94	114.04	113.7	113.74	874400.0
2006-04-27 16:00:00	DIA	ETF	113.74	113.86	113.7	113.72	67700.0
2006-04-27 17:00:00	DIA	ETF	113.7	113.7	113.68	113.68	8000.0
2006-04-27 07:00:00	GLD	ETF	62.75	62.84	62.71	62.71	8400.0
2006-04-27 08:00:00	GLD	ETF	62.68	62.92	62.22	62.92	387000.0
2006-04-27 09:00:00	GLD	ETF	62.9	63.27	62.76	63.25	1292600.0
2006-04-27 10:00:00	GLD	ETF	63.23	64.0	63.18	63.6	1528800.0
2006-04-27 11:00:00	GLD	ETF	63.61	63.86	63.4	63.47	794200.0
2006-04-27 12:00:00	GLD	ETF	63.5	63.7	63.16	63.39	650900.0
2006-04-27 13:00:00	GLD	ETF	63.37	63.37	62.83	63.02	800200.0

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

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