PREVIEW / etf_30min / 2008-11-20

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-20.parquet
  size:    194 KB
  rows:    6,914

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.33	80.66	740.0
2008-11-20 04:30:00	SPY	ETF	80.54	80.54	80.1	80.27	9320.0
2008-11-20 05:00:00	SPY	ETF	80.18	80.36	80.03	80.11	5400.0
2008-11-20 05:30:00	SPY	ETF	80.12	80.51	80.0	80.27	6900.0
2008-11-20 06:00:00	SPY	ETF	80.49	80.56	80.28	80.28	5631.0
2008-11-20 06:30:00	SPY	ETF	80.22	80.78	80.18	80.75	120800.0
2008-11-20 07:00:00	SPY	ETF	80.75	81.61	80.69	81.26	675096.0
2008-11-20 07:30:00	SPY	ETF	81.25	81.35	80.68	81.02	766193.0
2008-11-20 08:00:00	SPY	ETF	81.0	81.8	80.65	80.85	1417844.0
2008-11-20 08:30:00	SPY	ETF	80.83	80.87	79.56	79.82	4934435.0
2008-11-20 09:00:00	SPY	ETF	79.82	80.13	79.53	80.13	2975205.0
2008-11-20 09:30:00	SPY	ETF	80.13	80.69	78.67	78.98	71008605.0
2008-11-20 10:00:00	SPY	ETF	78.99	79.3	77.92	79.15	74741775.0
2008-11-20 10:30:00	SPY	ETF	79.15	80.81	78.7	80.58	78513367.0
2008-11-20 11:00:00	SPY	ETF	80.58	81.28	79.66	80.11	59931497.0
2008-11-20 11:30:00	SPY	ETF	80.11	80.28	79.51	79.6	25390666.0
2008-11-20 12:00:00	SPY	ETF	79.6	81.42	79.0	81.3	47697252.0
2008-11-20 12:30:00	SPY	ETF	81.3	82.51	81.05	81.28	53701670.0
2008-11-20 13:00:00	SPY	ETF	81.29	81.41	79.78	80.06	49562570.0
2008-11-20 13:30:00	SPY	ETF	80.07	80.95	79.52	80.79	39770375.0
2008-11-20 14:00:00	SPY	ETF	80.79	81.0	78.99	79.07	33870014.0
2008-11-20 14:30:00	SPY	ETF	79.0375	79.68	78.325	78.71	35860966.0
2008-11-20 15:00:00	SPY	ETF	78.72	79.34	77.48	77.74	61965584.0
2008-11-20 15:30:00	SPY	ETF	77.73	78.11	75.08	75.75	138231451.0
2008-11-20 16:00:00	SPY	ETF	75.83	78.9	75.04	78.5	20461861.0
2008-11-20 16:30:00	SPY	ETF	79.75	79.75	75.38	75.79	7413395.0
2008-11-20 17:00:00	SPY	ETF	75.81	76.5	75.56	75.57	511692.0
2008-11-20 17:30:00	SPY	ETF	75.57	75.57	75.34	75.48	288488.0
2008-11-20 18:00:00	SPY	ETF	75.49	75.83	75.49	75.81	262712.0
2008-11-20 18:30:00	SPY	ETF	75.77	76.11	75.77	76.03	174265.0
2008-11-20 19:00:00	SPY	ETF	76.0	76.3	75.7	75.71	160083.0
2008-11-20 19:30:00	SPY	ETF	75.71	75.99	75.71	75.95	105470.0
2008-11-20 04:00:00	QQQ	ETF	26.52	26.54	26.46	26.46	5100.0
2008-11-20 04:30:00	QQQ	ETF	26.5	26.5	26.46	26.47	2900.0
2008-11-20 05:00:00	QQQ	ETF	26.38	26.38	26.34	26.36	1190.0
2008-11-20 05:30:00	QQQ	ETF	26.4	26.57	26.4	26.45	6600.0
2008-11-20 06:00:00	QQQ	ETF	26.46	26.58	26.46	26.48	4780.0
2008-11-20 06:30:00	QQQ	ETF	26.46	26.57	26.46	26.57	15900.0
2008-11-20 07:00:00	QQQ	ETF	26.67	26.84	26.64	26.7	183656.0
2008-11-20 07:30:00	QQQ	ETF	26.71	26.79	26.56	26.69	192858.0
2008-11-20 08:00:00	QQQ	ETF	26.69	26.79	26.57	26.64	345587.0
2008-11-20 08:30:00	QQQ	ETF	26.63	26.63	26.27	26.33	1202264.0
2008-11-20 09:00:00	QQQ	ETF	26.33	26.54	26.26	26.53	1415745.0
2008-11-20 09:30:00	QQQ	ETF	26.54	26.7	26.21	26.36	27247758.0
2008-11-20 10:00:00	QQQ	ETF	26.36	26.57	26.0	26.55	31348480.0
2008-11-20 10:30:00	QQQ	ETF	26.55	27.1	26.4	27.01	33006065.0
2008-11-20 11:00:00	QQQ	ETF	27.01	27.31	26.8	26.9585	30025766.0
2008-11-20 11:30:00	QQQ	ETF	26.95	27.06	26.81	26.82	11315603.0
2008-11-20 12:00:00	QQQ	ETF	26.82	27.25	26.57	27.19	22996681.0
2008-11-20 12:30:00	QQQ	ETF	27.2	27.45	27.1	27.13	21574516.0

> showing 50 of 6,914 rows — these rows as CSV

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