PREVIEW / etf_1hour / 2008-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-20.parquet
  size:    121 KB
  rows:    3,993

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-11-20 04:00:00	SPY	ETF	80.51	80.66	80.1	80.27	10060.0
2008-11-20 05:00:00	SPY	ETF	80.18	80.51	80.0	80.27	12300.0
2008-11-20 06:00:00	SPY	ETF	80.49	80.78	80.18	80.75	126431.0
2008-11-20 07:00:00	SPY	ETF	80.75	81.61	80.68	81.02	1441289.0
2008-11-20 08:00:00	SPY	ETF	81.0	81.8	79.56	79.82	6352279.0
2008-11-20 09:00:00	SPY	ETF	79.82	80.69	78.67	78.98	73983810.0
2008-11-20 10:00:00	SPY	ETF	78.99	80.81	77.92	80.58	153255142.0
2008-11-20 11:00:00	SPY	ETF	80.58	81.28	79.51	79.6	85322163.0
2008-11-20 12:00:00	SPY	ETF	79.6	82.51	79.0	81.28	101398922.0
2008-11-20 13:00:00	SPY	ETF	81.29	81.41	79.52	80.79	89332945.0
2008-11-20 14:00:00	SPY	ETF	80.79	81.0	78.325	78.71	69730980.0
2008-11-20 15:00:00	SPY	ETF	78.72	79.34	75.08	75.75	200197035.0
2008-11-20 16:00:00	SPY	ETF	75.83	79.75	75.04	75.79	27875256.0
2008-11-20 17:00:00	SPY	ETF	75.81	76.5	75.34	75.48	800180.0
2008-11-20 18:00:00	SPY	ETF	75.49	76.11	75.49	76.03	436977.0
2008-11-20 19:00:00	SPY	ETF	76.0	76.3	75.7	75.95	265553.0
2008-11-20 04:00:00	QQQ	ETF	26.52	26.54	26.46	26.47	8000.0
2008-11-20 05:00:00	QQQ	ETF	26.38	26.57	26.34	26.45	7790.0
2008-11-20 06:00:00	QQQ	ETF	26.46	26.58	26.46	26.57	20680.0
2008-11-20 07:00:00	QQQ	ETF	26.67	26.84	26.56	26.69	376514.0
2008-11-20 08:00:00	QQQ	ETF	26.69	26.79	26.27	26.33	1547851.0
2008-11-20 09:00:00	QQQ	ETF	26.33	26.7	26.21	26.36	28663503.0
2008-11-20 10:00:00	QQQ	ETF	26.36	27.1	26.0	27.01	64354545.0
2008-11-20 11:00:00	QQQ	ETF	27.01	27.31	26.8	26.82	41341369.0
2008-11-20 12:00:00	QQQ	ETF	26.82	27.45	26.57	27.13	44571197.0
2008-11-20 13:00:00	QQQ	ETF	27.12	27.16	26.62	27.1	40127711.0
2008-11-20 14:00:00	QQQ	ETF	27.1	27.1595	26.24	26.36	34643220.0
2008-11-20 15:00:00	QQQ	ETF	26.36	26.53	25.47	25.58	70538083.0
2008-11-20 16:00:00	QQQ	ETF	25.58	26.7686	25.4	25.78	10922708.0
2008-11-20 17:00:00	QQQ	ETF	25.76	25.8	25.67	25.72	231698.0
2008-11-20 18:00:00	QQQ	ETF	25.73	25.79	25.71	25.78	161742.0
2008-11-20 19:00:00	QQQ	ETF	25.8	25.86	25.74	25.83	89746.0
2008-11-20 06:00:00	IWM	ETF	41.04	41.04	41.04	41.04	200.0
2008-11-20 07:00:00	IWM	ETF	41.4	41.61	41.18	41.38	88825.0
2008-11-20 08:00:00	IWM	ETF	41.35	41.49	40.73	40.74	406157.0
2008-11-20 09:00:00	IWM	ETF	40.75	41.06	40.07	40.26	10751076.0
2008-11-20 10:00:00	IWM	ETF	40.25	41.29	39.66	40.94	20998062.0
2008-11-20 11:00:00	IWM	ETF	40.94	41.52	40.69	40.8	13892314.0
2008-11-20 12:00:00	IWM	ETF	40.8	41.93	40.33	41.05	18247702.0
2008-11-20 13:00:00	IWM	ETF	41.05	41.47	40.5	41.14	14677871.0
2008-11-20 14:00:00	IWM	ETF	41.15	41.27	39.8	40.01	12244162.0
2008-11-20 15:00:00	IWM	ETF	39.99	40.41	38.44	38.58	37854620.0
2008-11-20 16:00:00	IWM	ETF	38.58	41.31	38.14	38.8	6452986.0
2008-11-20 17:00:00	IWM	ETF	38.8	41.31	38.63	38.66	1164779.0
2008-11-20 19:00:00	IWM	ETF	38.99	39.04	38.99	39.04	200.0
2008-11-20 06:00:00	DIA	ETF	79.78	80.0	79.63	80.0	800.0
2008-11-20 07:00:00	DIA	ETF	80.22	80.52	80.04	80.2	5521.0
2008-11-20 08:00:00	DIA	ETF	80.22	80.36	79.0	79.19	161118.0
2008-11-20 09:00:00	DIA	ETF	79.24	79.91	78.46	78.8	7815233.0
2008-11-20 10:00:00	DIA	ETF	78.77	80.44	78.03	80.26	13198493.0

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

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