PREVIEW / etf_30min / 2008-12-30

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-30.parquet
  size:    209 KB
  rows:    6,801

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-12-30 04:00:00	SPY	ETF	88.04	88.07	88.04	88.07	2214.0
2008-12-30 04:30:00	SPY	ETF	88.0	88.0	87.99	87.99	700.0
2008-12-30 05:00:00	SPY	ETF	87.98	88.02	87.98	88.02	385.0
2008-12-30 05:30:00	SPY	ETF	87.93	87.93	87.93	87.93	100.0
2008-12-30 06:00:00	SPY	ETF	87.79	87.79	87.73	87.73	785.0
2008-12-30 06:30:00	SPY	ETF	87.66	87.66	87.5	87.66	2300.0
2008-12-30 07:00:00	SPY	ETF	87.68	87.81	87.62	87.7	78600.0
2008-12-30 07:30:00	SPY	ETF	87.7	87.75	87.55	87.71	346908.0
2008-12-30 08:00:00	SPY	ETF	87.71	88.06	87.7	87.82	533270.0
2008-12-30 08:30:00	SPY	ETF	87.82	87.82	87.65	87.67	577969.0
2008-12-30 09:00:00	SPY	ETF	87.67	87.8	87.41	87.48	1060468.0
2008-12-30 09:30:00	SPY	ETF	87.51	87.67	87.25	87.28	15556967.0
2008-12-30 10:00:00	SPY	ETF	87.28	87.81	87.09	87.79	15788363.0
2008-12-30 10:30:00	SPY	ETF	87.79	87.94	87.649	87.68	10071855.0
2008-12-30 11:00:00	SPY	ETF	87.68	88.0	87.58	87.9801	8698798.0
2008-12-30 11:30:00	SPY	ETF	87.99	88.47	87.99	88.35	13316647.0
2008-12-30 12:00:00	SPY	ETF	88.36	88.48	88.15	88.25	9764594.0
2008-12-30 12:30:00	SPY	ETF	88.25	88.32	87.85	88.18	15959955.0
2008-12-30 13:00:00	SPY	ETF	88.18	88.23	87.79	88.02	9188027.0
2008-12-30 13:30:00	SPY	ETF	88.01	88.2	87.8	87.8899	6657762.0
2008-12-30 14:00:00	SPY	ETF	87.89	88.24	87.72	88.21	7685210.0
2008-12-30 14:30:00	SPY	ETF	88.22	88.3	87.99	88.03	7753695.0
2008-12-30 15:00:00	SPY	ETF	88.03	88.22	87.8	88.15	8857463.0
2008-12-30 15:30:00	SPY	ETF	88.15	89.05	87.32	88.9	29800812.0
2008-12-30 16:00:00	SPY	ETF	88.88	89.12	88.86	88.94	5127111.0
2008-12-30 16:30:00	SPY	ETF	88.96	89.21	88.96	89.15	569868.0
2008-12-30 17:00:00	SPY	ETF	89.14	89.24	89.14	89.22	71698.0
2008-12-30 17:30:00	SPY	ETF	89.2	89.2	88.97	89.15	59630.0
2008-12-30 18:00:00	SPY	ETF	89.17	89.42	89.17	89.38	105479.0
2008-12-30 18:30:00	SPY	ETF	89.4	89.44	89.32	89.32	31540.0
2008-12-30 19:00:00	SPY	ETF	89.32	89.38	89.17	89.17	210000.0
2008-12-30 19:30:00	SPY	ETF	89.37	89.39	89.35	89.35	12519.0
2008-12-30 04:00:00	QQQ	ETF	29.22	29.22	29.22	29.22	575.0
2008-12-30 05:30:00	QQQ	ETF	29.21	29.21	29.21	29.21	100.0
2008-12-30 06:00:00	QQQ	ETF	29.18	29.18	29.06	29.12	66147.0
2008-12-30 06:30:00	QQQ	ETF	29.08	29.12	29.01	29.12	16255.0
2008-12-30 07:00:00	QQQ	ETF	29.12	29.17	29.12	29.12	10530.0
2008-12-30 07:30:00	QQQ	ETF	29.12	29.15	29.08	29.14	22799.0
2008-12-30 08:00:00	QQQ	ETF	29.15	29.18	29.09	29.13	185288.0
2008-12-30 08:30:00	QQQ	ETF	29.12	29.14	29.05	29.05	205305.0
2008-12-30 09:00:00	QQQ	ETF	29.05	29.11	28.96	28.97	482517.0
2008-12-30 09:30:00	QQQ	ETF	28.97	29.11	28.94	29.01	7317903.0
2008-12-30 10:00:00	QQQ	ETF	29.01	29.238	28.96	29.22	6674154.0
2008-12-30 10:30:00	QQQ	ETF	29.23	29.31	29.19	29.2	4958272.0
2008-12-30 11:00:00	QQQ	ETF	29.19	29.29	29.16	29.28	4005700.0
2008-12-30 11:30:00	QQQ	ETF	29.27	29.59	29.27	29.54	8178243.0
2008-12-30 12:00:00	QQQ	ETF	29.54	29.57	29.41	29.46	4274433.0
2008-12-30 12:30:00	QQQ	ETF	29.45	29.49	29.29	29.4	6525826.0
2008-12-30 13:00:00	QQQ	ETF	29.3901	29.42	29.3	29.36	3297784.0
2008-12-30 13:30:00	QQQ	ETF	29.36	29.4	29.26	29.2799	3670891.0

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

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