PREVIEW / etf_1hour / 2008-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-16.parquet
  size:    109 KB
  rows:    3,507

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
2008-04-16 04:00:00	SPY	ETF	133.92	133.92	133.92	133.92	200.0
2008-04-16 05:00:00	SPY	ETF	133.95	133.95	133.62	133.62	6700.0
2008-04-16 06:00:00	SPY	ETF	133.67	133.95	133.66	133.86	117700.0
2008-04-16 07:00:00	SPY	ETF	133.99	134.19	133.84	134.08	1150918.0
2008-04-16 08:00:00	SPY	ETF	134.1	134.56	133.93	134.56	8197864.0
2008-04-16 09:00:00	SPY	ETF	134.56	134.95	134.51	134.72	22141673.0
2008-04-16 10:00:00	SPY	ETF	134.72	135.51	134.52	135.49	39670324.0
2008-04-16 11:00:00	SPY	ETF	135.49	135.57	135.06	135.19	19667175.0
2008-04-16 12:00:00	SPY	ETF	135.19	135.69	135.17	135.59	14556081.0
2008-04-16 13:00:00	SPY	ETF	135.6	135.69	134.4	135.439	14093706.0
2008-04-16 14:00:00	SPY	ETF	135.4396	135.85	135.16	135.739	19211942.0
2008-04-16 15:00:00	SPY	ETF	135.73	136.5	135.7	136.22	33741840.0
2008-04-16 16:00:00	SPY	ETF	136.23	137.0	133.3965	136.85	12480598.0
2008-04-16 17:00:00	SPY	ETF	136.85	136.86	136.65	136.77	592295.0
2008-04-16 18:00:00	SPY	ETF	136.76	136.77	136.68	136.75	52486.0
2008-04-16 19:00:00	SPY	ETF	136.75	136.77	136.57	136.64	70537.0
2008-04-16 05:00:00	QQQ	ETF	44.57	44.57	44.56	44.56	400.0
2008-04-16 06:00:00	QQQ	ETF	44.58	44.59	44.57	44.59	2000.0
2008-04-16 07:00:00	QQQ	ETF	44.66	44.67	44.59	44.65	111578.0
2008-04-16 08:00:00	QQQ	ETF	44.65	44.77	44.64	44.75	3396891.0
2008-04-16 09:00:00	QQQ	ETF	44.75	44.79	44.64	44.68	14471860.0
2008-04-16 10:00:00	QQQ	ETF	44.69	45.11	44.66	45.108	26511556.0
2008-04-16 11:00:00	QQQ	ETF	45.1	45.25	45.03	45.16	16645318.0
2008-04-16 12:00:00	QQQ	ETF	45.17	45.33	45.16	45.28	11790472.0
2008-04-16 13:00:00	QQQ	ETF	45.2725	45.315	45.12	45.1695	9886292.0
2008-04-16 14:00:00	QQQ	ETF	45.16	45.36	45.1	45.3105	12014408.0
2008-04-16 15:00:00	QQQ	ETF	45.32	45.48	45.28	45.36	21577413.0
2008-04-16 16:00:00	QQQ	ETF	45.37	45.86	45.35	45.68	12777387.0
2008-04-16 17:00:00	QQQ	ETF	45.67	45.7	45.42	45.67	2987048.0
2008-04-16 18:00:00	QQQ	ETF	45.66	45.66	45.57	45.65	74183.0
2008-04-16 19:00:00	QQQ	ETF	45.64	45.65	45.59	45.62	33858.0
2008-04-16 06:00:00	IWM	ETF	69.29	69.3	69.28	69.28	2600.0
2008-04-16 07:00:00	IWM	ETF	69.37	69.55	69.37	69.5	179567.0
2008-04-16 08:00:00	IWM	ETF	69.56	69.74	69.3	69.71	1974104.0
2008-04-16 09:00:00	IWM	ETF	69.72	70.18	69.65	70.09	6671936.0
2008-04-16 10:00:00	IWM	ETF	70.09	70.81	70.0	70.76	19484212.0
2008-04-16 11:00:00	IWM	ETF	70.75	70.76	70.52	70.57	7897870.0
2008-04-16 12:00:00	IWM	ETF	70.57	70.8	70.57	70.73	5773394.0
2008-04-16 13:00:00	IWM	ETF	70.74	70.78	70.54	70.58	4725896.0
2008-04-16 14:00:00	IWM	ETF	70.58	70.83	69.8	70.76	7518383.0
2008-04-16 15:00:00	IWM	ETF	70.77	71.19	70.74	71.0	12533097.0
2008-04-16 16:00:00	IWM	ETF	71.0	71.4	70.91	71.28	4363235.0
2008-04-16 17:00:00	IWM	ETF	71.25	71.26	70.93	71.1	175733.0
2008-04-16 18:00:00	IWM	ETF	71.15	71.19	71.15	71.17	25423.0
2008-04-16 19:00:00	IWM	ETF	71.19	71.19	71.13	71.18	1239.0
2008-04-16 06:00:00	DIA	ETF	123.9	123.91	123.82	123.85	4800.0
2008-04-16 07:00:00	DIA	ETF	124.09	124.15	124.09	124.15	17081.0
2008-04-16 08:00:00	DIA	ETF	124.2	124.48	124.1	124.48	55632.0
2008-04-16 09:00:00	DIA	ETF	124.49	125.02	124.49	124.9	2106455.0
2008-04-16 10:00:00	DIA	ETF	124.9	125.65	124.71	125.64	3273147.0

> showing 50 of 3,507 rows — these rows as CSV

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