PREVIEW / etf_30min / 2010-02-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-23.parquet
  size:    249 KB
  rows:    8,287

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
2010-02-23 04:00:00	SPY	ETF	111.48	111.48	111.44	111.44	414.0
2010-02-23 04:30:00	SPY	ETF	111.47	111.47	111.47	111.47	100.0
2010-02-23 05:00:00	SPY	ETF	111.44	111.44	111.29	111.29	200.0
2010-02-23 05:30:00	SPY	ETF	111.01	111.02	110.99	111.02	2900.0
2010-02-23 06:00:00	SPY	ETF	110.94	110.94	110.8	110.8	1300.0
2010-02-23 06:30:00	SPY	ETF	110.91	110.92	110.73	110.77	56125.0
2010-02-23 07:00:00	SPY	ETF	110.85	110.99	110.79	110.88	240676.0
2010-02-23 07:30:00	SPY	ETF	110.9	111.0	110.74	110.91	1286914.0
2010-02-23 08:00:00	SPY	ETF	110.97	111.03	110.83	110.86	2090530.0
2010-02-23 08:30:00	SPY	ETF	110.85	110.86	110.68	110.84	1099822.0
2010-02-23 09:00:00	SPY	ETF	110.84	110.87	110.75	110.86	1234554.0
2010-02-23 09:30:00	SPY	ETF	110.86	111.2	110.74	110.99	19763815.0
2010-02-23 10:00:00	SPY	ETF	110.99	111.1254	109.9	110.04	36996422.0
2010-02-23 10:30:00	SPY	ETF	110.04	110.2	109.84	110.16	13855753.0
2010-02-23 11:00:00	SPY	ETF	110.16	110.27	109.96	110.04	10827525.0
2010-02-23 11:30:00	SPY	ETF	110.04	110.2	109.99	110.04	8236286.0
2010-02-23 12:00:00	SPY	ETF	110.04	110.06	109.69	109.7605	9966656.0
2010-02-23 12:30:00	SPY	ETF	109.77	109.86	109.58	109.82	14109144.0
2010-02-23 13:00:00	SPY	ETF	109.83	111.1171	109.68	109.91	9623127.0
2010-02-23 13:30:00	SPY	ETF	109.9138	109.96	109.6	109.68	9059045.0
2010-02-23 14:00:00	SPY	ETF	109.68	109.87	109.52	109.74	10967428.0
2010-02-23 14:30:00	SPY	ETF	109.74	110.1	109.65	110.0	12865751.0
2010-02-23 15:00:00	SPY	ETF	110.0	111.1171	109.9	110.1	10705055.0
2010-02-23 15:30:00	SPY	ETF	110.11	110.15	109.7	109.79	19920101.0
2010-02-23 16:00:00	SPY	ETF	109.79	110.8428	109.65	110.13	7141169.0
2010-02-23 16:30:00	SPY	ETF	110.12	111.117	110.11	110.16	1973168.0
2010-02-23 17:00:00	SPY	ETF	110.14	110.15	110.09	110.1	78832.0
2010-02-23 17:30:00	SPY	ETF	110.09	111.1171	110.09	110.16	1171411.0
2010-02-23 18:00:00	SPY	ETF	110.16	110.16	110.08	110.08	191813.0
2010-02-23 18:30:00	SPY	ETF	110.1	110.11	109.81	110.08	273587.0
2010-02-23 19:00:00	SPY	ETF	110.06	110.08	110.03	110.06	38509.0
2010-02-23 19:30:00	SPY	ETF	110.06	110.1	110.03	110.1	70055.0
2010-02-23 04:00:00	QQQ	ETF	44.92	44.92	44.92	44.92	200.0
2010-02-23 04:30:00	QQQ	ETF	44.93	44.93	44.93	44.93	700.0
2010-02-23 05:00:00	QQQ	ETF	44.88	44.89	44.88	44.89	200.0
2010-02-23 05:30:00	QQQ	ETF	44.77	44.77	44.73	44.73	7900.0
2010-02-23 06:00:00	QQQ	ETF	44.64	44.64	44.61	44.63	2100.0
2010-02-23 06:30:00	QQQ	ETF	44.62	44.62	44.56	44.59	56555.0
2010-02-23 07:00:00	QQQ	ETF	44.65	44.68	44.65	44.67	45897.0
2010-02-23 07:30:00	QQQ	ETF	44.67	44.69	44.61	44.65	506417.0
2010-02-23 08:00:00	QQQ	ETF	44.65	44.69	44.64	44.66	1053586.0
2010-02-23 08:30:00	QQQ	ETF	44.66	44.7	44.6	44.7	376938.0
2010-02-23 09:00:00	QQQ	ETF	44.67	44.69	44.63	44.69	803496.0
2010-02-23 09:30:00	QQQ	ETF	44.69	44.74	44.55	44.66	9065564.0
2010-02-23 10:00:00	QQQ	ETF	44.66	44.71	44.18	44.22	18175308.0
2010-02-23 10:30:00	QQQ	ETF	44.2199	44.28	44.13	44.26	5717041.0
2010-02-23 11:00:00	QQQ	ETF	44.25	44.3	44.13	44.15	4713369.0
2010-02-23 11:30:00	QQQ	ETF	44.15	44.21	44.11	44.16	2519053.0
2010-02-23 12:00:00	QQQ	ETF	44.16	44.16	43.95	44.0	5267654.0
2010-02-23 12:30:00	QQQ	ETF	43.99	44.08	43.97	44.0701	6468881.0

> showing 50 of 8,287 rows — these rows as CSV

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