PREVIEW / etf_30min / 2009-07-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-20.parquet
  size:    232 KB
  rows:    7,641

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-07-20 04:00:00	SPY	ETF	94.41	94.46	94.41	94.41	1300.0
2009-07-20 04:30:00	SPY	ETF	94.38	94.38	94.35	94.36	500.0
2009-07-20 05:00:00	SPY	ETF	94.46	94.83	94.46	94.83	16100.0
2009-07-20 05:30:00	SPY	ETF	94.78	94.78	94.75	94.75	800.0
2009-07-20 06:00:00	SPY	ETF	94.8	94.91	94.8	94.91	40800.0
2009-07-20 06:30:00	SPY	ETF	94.86	94.91	94.76	94.76	317410.0
2009-07-20 07:00:00	SPY	ETF	94.77	94.8	94.69	94.75	271252.0
2009-07-20 07:30:00	SPY	ETF	94.73	94.83	94.67	94.73	293356.0
2009-07-20 08:00:00	SPY	ETF	94.72	94.81	94.58	94.58	444532.0
2009-07-20 08:30:00	SPY	ETF	94.59	94.98	94.55	94.7	1454448.0
2009-07-20 09:00:00	SPY	ETF	94.71	94.84	94.67	94.68	2012243.0
2009-07-20 09:30:00	SPY	ETF	94.68	95.0	94.6	94.75	20092706.0
2009-07-20 10:00:00	SPY	ETF	94.76	95.0	94.45	94.53	17690843.0
2009-07-20 10:30:00	SPY	ETF	94.52	94.75	94.19	94.37	13373704.0
2009-07-20 11:00:00	SPY	ETF	94.3617	94.61	94.3	94.59	7688647.0
2009-07-20 11:30:00	SPY	ETF	94.59	94.68	94.52	94.56	6218462.0
2009-07-20 12:00:00	SPY	ETF	94.57	94.81	94.54	94.79	5354165.0
2009-07-20 12:30:00	SPY	ETF	94.79	94.9	94.74	94.76	4400555.0
2009-07-20 13:00:00	SPY	ETF	94.76	94.82	94.55	94.58	6393238.0
2009-07-20 13:30:00	SPY	ETF	94.58	94.78	94.47	94.74	8766365.0
2009-07-20 14:00:00	SPY	ETF	94.74	94.95	94.62	94.7	7147551.0
2009-07-20 14:30:00	SPY	ETF	94.7	94.85	94.65	94.73	9576369.0
2009-07-20 15:00:00	SPY	ETF	94.74	95.21	94.73	95.09	12425730.0
2009-07-20 15:30:00	SPY	ETF	95.09	95.29	94.8	95.13	22373470.0
2009-07-20 16:00:00	SPY	ETF	95.12	95.37	95.03	95.21	6142511.0
2009-07-20 16:30:00	SPY	ETF	95.21	95.25	95.09	95.12	747542.0
2009-07-20 17:00:00	SPY	ETF	95.13	95.16	95.11	95.14	27169.0
2009-07-20 17:30:00	SPY	ETF	95.14	95.2	95.13	95.17	31862.0
2009-07-20 18:00:00	SPY	ETF	95.17	95.17	95.07	95.11	49544.0
2009-07-20 18:30:00	SPY	ETF	95.11	95.12	95.08	95.09	41147.0
2009-07-20 19:00:00	SPY	ETF	95.09	95.19	95.08	95.18	14366.0
2009-07-20 19:30:00	SPY	ETF	95.15	95.19	95.09	95.11	12115.0
2009-07-20 04:00:00	QQQ	ETF	37.75	37.75	37.73	37.73	294.0
2009-07-20 04:30:00	QQQ	ETF	37.69	37.69	37.69	37.69	100.0
2009-07-20 05:30:00	QQQ	ETF	37.81	37.81	37.81	37.81	100.0
2009-07-20 06:00:00	QQQ	ETF	37.88	37.91	37.88	37.91	20200.0
2009-07-20 06:30:00	QQQ	ETF	37.9	37.9	37.85	37.85	37700.0
2009-07-20 07:00:00	QQQ	ETF	37.8	37.81	37.74	37.75	30240.0
2009-07-20 07:30:00	QQQ	ETF	37.76	37.82	37.75	37.79	344229.0
2009-07-20 08:00:00	QQQ	ETF	37.77	37.82	37.7	37.7	394687.0
2009-07-20 08:30:00	QQQ	ETF	37.7	37.92	37.67	37.72	509867.0
2009-07-20 09:00:00	QQQ	ETF	37.72	37.76	37.71	37.74	534328.0
2009-07-20 09:30:00	QQQ	ETF	37.74	37.89	37.61	37.88	16433811.0
2009-07-20 10:00:00	QQQ	ETF	37.88	37.97	37.68	37.72	9761030.0
2009-07-20 10:30:00	QQQ	ETF	37.71	37.73	37.62	37.68	5832121.0
2009-07-20 11:00:00	QQQ	ETF	37.69	37.78	37.66	37.77	3267542.0
2009-07-20 11:30:00	QQQ	ETF	37.77	37.85	37.75	37.8	4567411.0
2009-07-20 12:00:00	QQQ	ETF	37.8	37.88	37.79	37.8701	4172103.0
2009-07-20 12:30:00	QQQ	ETF	37.88	37.92	37.86	37.8702	2362164.0
2009-07-20 13:00:00	QQQ	ETF	37.88	37.9	37.77	37.78	3578703.0

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

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