PREVIEW / etf_30min / 2009-03-18

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-18.parquet
  size:    213 KB
  rows:    7,045

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
2009-03-18 04:00:00	SPY	ETF	78.26	78.29	78.26	78.29	200.0
2009-03-18 04:30:00	SPY	ETF	78.07	78.07	78.07	78.07	700.0
2009-03-18 05:00:00	SPY	ETF	77.99	78.06	77.9	77.9	800.0
2009-03-18 05:30:00	SPY	ETF	77.85	78.03	77.74	77.8	9000.0
2009-03-18 06:00:00	SPY	ETF	77.92	78.04	77.92	77.98	11200.0
2009-03-18 06:30:00	SPY	ETF	77.98	78.01	77.9	77.9	41200.0
2009-03-18 07:00:00	SPY	ETF	77.98	78.26	77.93	78.15	101673.0
2009-03-18 07:30:00	SPY	ETF	78.15	78.17	77.88	77.9	381579.0
2009-03-18 08:00:00	SPY	ETF	77.91	78.12	77.77	77.93	1191457.0
2009-03-18 08:30:00	SPY	ETF	77.93	78.02	77.73	77.85	1062240.0
2009-03-18 09:00:00	SPY	ETF	77.86	78.0	77.56	77.8	2419736.0
2009-03-18 09:30:00	SPY	ETF	77.81	77.95	77.4406	77.71	32346421.0
2009-03-18 10:00:00	SPY	ETF	77.71	77.83	77.27	77.3799	25749868.0
2009-03-18 10:30:00	SPY	ETF	77.37	77.75	77.07	77.7401	30613529.0
2009-03-18 11:00:00	SPY	ETF	77.74	77.88	77.42	77.51	16228583.0
2009-03-18 11:30:00	SPY	ETF	77.52	77.83	77.36	77.83	14169755.0
2009-03-18 12:00:00	SPY	ETF	77.83	78.323	77.1	78.08	22666398.0
2009-03-18 12:30:00	SPY	ETF	78.07	78.35	77.82	78.28	20228563.0
2009-03-18 13:00:00	SPY	ETF	78.28	78.31	77.99	78.23	16811611.0
2009-03-18 13:30:00	SPY	ETF	78.23	78.64	78.2	78.37	14495105.0
2009-03-18 14:00:00	SPY	ETF	78.36	80.4	78.2	79.73	71932561.0
2009-03-18 14:30:00	SPY	ETF	79.73	80.9	77.7	80.6	59059933.0
2009-03-18 15:00:00	SPY	ETF	80.6	80.63	78.9	79.5	59337885.0
2009-03-18 15:30:00	SPY	ETF	79.51	80.0	79.04	79.89	56942804.0
2009-03-18 16:00:00	SPY	ETF	79.89	80.1	78.2	79.94	17024789.0
2009-03-18 16:30:00	SPY	ETF	79.94	80.2128	77.1483	80.05	2687965.0
2009-03-18 17:00:00	SPY	ETF	80.05	80.1	79.97	80.03	2128260.0
2009-03-18 17:30:00	SPY	ETF	80.01	80.05	79.92	79.98	5072974.0
2009-03-18 18:00:00	SPY	ETF	79.95	79.96	79.82	79.83	73013.0
2009-03-18 18:30:00	SPY	ETF	79.83	79.83	79.67	79.73	146054.0
2009-03-18 19:00:00	SPY	ETF	79.73	79.82	79.71	79.82	38683.0
2009-03-18 19:30:00	SPY	ETF	79.83	79.83	79.69	79.69	52744.0
2009-03-18 05:00:00	QQQ	ETF	29.25	29.25	29.25	29.25	200.0
2009-03-18 06:00:00	QQQ	ETF	29.29	29.29	29.29	29.29	100.0
2009-03-18 06:30:00	QQQ	ETF	29.29	29.3	29.26	29.28	36915.0
2009-03-18 07:00:00	QQQ	ETF	29.26	29.41	29.26	29.38	235262.0
2009-03-18 07:30:00	QQQ	ETF	29.37	29.37	29.28	29.28	175454.0
2009-03-18 08:00:00	QQQ	ETF	29.28	29.31	29.25	29.3	360767.0
2009-03-18 08:30:00	QQQ	ETF	29.3	29.31	29.25	29.28	462383.0
2009-03-18 09:00:00	QQQ	ETF	29.28	29.29	29.2	29.23	591899.0
2009-03-18 09:30:00	QQQ	ETF	29.23	29.43	29.18	29.34	12923347.0
2009-03-18 10:00:00	QQQ	ETF	29.34	29.41	29.16	29.18	12006498.0
2009-03-18 10:30:00	QQQ	ETF	29.17	29.31	29.08	29.31	8883824.0
2009-03-18 11:00:00	QQQ	ETF	29.3	29.36	29.14	29.2	9026474.0
2009-03-18 11:30:00	QQQ	ETF	29.2098	29.35	29.17	29.35	5225205.0
2009-03-18 12:00:00	QQQ	ETF	29.35	29.53	29.2	29.45	10524816.0
2009-03-18 12:30:00	QQQ	ETF	29.46	29.54	29.38	29.52	4907248.0
2009-03-18 13:00:00	QQQ	ETF	29.52	29.521	29.39	29.43	7784237.0
2009-03-18 13:30:00	QQQ	ETF	29.4395	29.59	29.4	29.5	7791538.0
2009-03-18 14:00:00	QQQ	ETF	29.5	30.09	29.45	29.92	31188331.0

> showing 50 of 7,045 rows — these rows as CSV

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