PREVIEW / etf_1hour / 2008-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-01.parquet
  size:    100 KB
  rows:    3,350

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-02-01 05:00:00	SPY	ETF	137.8	137.82	137.8	137.82	17500.0
2008-02-01 06:00:00	SPY	ETF	137.92	139.25	137.92	139.17	377900.0
2008-02-01 07:00:00	SPY	ETF	139.29	139.61	138.75	139.41	3585400.0
2008-02-01 08:00:00	SPY	ETF	139.4	139.45	137.29	137.84	18681500.0
2008-02-01 09:00:00	SPY	ETF	137.84	138.71	137.44	138.55	22358234.0
2008-02-01 10:00:00	SPY	ETF	138.55	139.61	137.52	137.91	56906289.0
2008-02-01 11:00:00	SPY	ETF	137.91	138.71	137.7	138.54	22071404.0
2008-02-01 12:00:00	SPY	ETF	138.53	138.63	137.93	138.02	14824196.0
2008-02-01 13:00:00	SPY	ETF	138.03	138.82	138.02	138.34	14656608.0
2008-02-01 14:00:00	SPY	ETF	138.33	139.32	138.28	139.18	17683873.0
2008-02-01 15:00:00	SPY	ETF	139.17	139.51	138.85	139.45	28506560.0
2008-02-01 16:00:00	SPY	ETF	139.47	139.8	138.07	139.7	4725719.0
2008-02-01 17:00:00	SPY	ETF	139.7	139.72	139.5	139.6	28400.0
2008-02-01 18:00:00	SPY	ETF	139.56	139.63	139.49	139.55	338300.0
2008-02-01 19:00:00	SPY	ETF	139.55	139.58	139.5	139.55	6600.0
2008-02-01 06:00:00	QQQ	ETF	45.28	45.99	45.28	45.95	411520.0
2008-02-01 07:00:00	QQQ	ETF	45.95	46.03	45.67	45.92	1563919.0
2008-02-01 08:00:00	QQQ	ETF	45.9	45.98	45.4	45.6	9730863.0
2008-02-01 09:00:00	QQQ	ETF	45.6	45.88	45.1	45.5	23395196.0
2008-02-01 10:00:00	QQQ	ETF	45.5099	45.88	44.88	44.98	47627228.0
2008-02-01 11:00:00	QQQ	ETF	44.97	45.3	44.9	45.26	15713809.0
2008-02-01 12:00:00	QQQ	ETF	45.2601	45.27	45.05	45.1	11304062.0
2008-02-01 13:00:00	QQQ	ETF	45.1001	45.45	45.1	45.2801	13135647.0
2008-02-01 14:00:00	QQQ	ETF	45.29	45.71	45.24	45.65	16259059.0
2008-02-01 15:00:00	QQQ	ETF	45.6485	45.76	45.5	45.6	18040830.0
2008-02-01 16:00:00	QQQ	ETF	45.6	45.77	45.5278	45.65	5173668.0
2008-02-01 17:00:00	QQQ	ETF	45.65	45.69	45.58	45.64	28871.0
2008-02-01 18:00:00	QQQ	ETF	45.65	45.66	45.64	45.64	15328.0
2008-02-01 19:00:00	QQQ	ETF	45.63	45.7	45.6	45.7	25253.0
2008-02-01 06:00:00	IWM	ETF	71.5	72.04	71.5	71.92	121800.0
2008-02-01 07:00:00	IWM	ETF	72.1	72.48	71.98	72.36	487300.0
2008-02-01 08:00:00	IWM	ETF	72.36	72.37	71.34	71.45	3784900.0
2008-02-01 09:00:00	IWM	ETF	71.48	72.1	71.19	71.8	14817453.0
2008-02-01 10:00:00	IWM	ETF	71.8	72.75	71.0	71.37	30101986.0
2008-02-01 11:00:00	IWM	ETF	71.36	71.84	71.2	71.69	7974750.0
2008-02-01 12:00:00	IWM	ETF	71.68	71.85	71.4	71.41	5870308.0
2008-02-01 13:00:00	IWM	ETF	71.41	72.1	71.39	71.87	6527255.0
2008-02-01 14:00:00	IWM	ETF	71.87	72.49	71.81	72.36	9284013.0
2008-02-01 15:00:00	IWM	ETF	72.36	72.88	72.29	72.61	15529524.0
2008-02-01 16:00:00	IWM	ETF	72.62	72.91	72.6	72.9	6097600.0
2008-02-01 17:00:00	IWM	ETF	72.9	72.91	72.75	72.75	9400.0
2008-02-01 18:00:00	IWM	ETF	72.8	72.8	72.63	72.63	5800.0
2008-02-01 19:00:00	IWM	ETF	72.8	72.8	72.8	72.8	900.0
2008-02-01 06:00:00	DIA	ETF	126.67	126.9	126.67	126.9	200.0
2008-02-01 07:00:00	DIA	ETF	127.38	127.72	127.19	127.6	23400.0
2008-02-01 08:00:00	DIA	ETF	127.59	127.64	126.33	126.35	302620.0
2008-02-01 09:00:00	DIA	ETF	126.37	136.52	126.1	126.87	2622785.0
2008-02-01 10:00:00	DIA	ETF	126.87	127.61	125.96	126.24	6144024.0
2008-02-01 11:00:00	DIA	ETF	126.24	126.85	126.07	126.67	2076853.0
2008-02-01 12:00:00	DIA	ETF	126.65	126.74	126.17	126.27	1174150.0

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

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