PREVIEW / etf_30min / 2011-04-11

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-11.parquet
  size:    286 KB
  rows:    9,398

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
2011-04-11 04:00:00	SPY	ETF	133.5	133.5	132.93	132.93	27700.0
2011-04-11 04:30:00	SPY	ETF	132.95	132.96	132.88	132.9	2800.0
2011-04-11 05:00:00	SPY	ETF	132.96	133.01	132.94	133.01	5600.0
2011-04-11 05:30:00	SPY	ETF	132.95	132.96	132.93	132.93	3000.0
2011-04-11 06:00:00	SPY	ETF	132.92	132.92	132.91	132.91	550.0
2011-04-11 06:30:00	SPY	ETF	133.08	133.28	133.08	133.23	21900.0
2011-04-11 07:00:00	SPY	ETF	133.2	133.21	133.1	133.16	167600.0
2011-04-11 07:30:00	SPY	ETF	133.13	133.16	133.0	133.03	379232.0
2011-04-11 08:00:00	SPY	ETF	133.01	133.3	132.82	133.01	652840.0
2011-04-11 08:30:00	SPY	ETF	133.0	133.12	132.97	133.07	319910.0
2011-04-11 09:00:00	SPY	ETF	133.07	133.09	132.97	132.99	449623.0
2011-04-11 09:30:00	SPY	ETF	133.0	133.45	132.98	133.27	16345120.0
2011-04-11 10:00:00	SPY	ETF	133.27	133.36	132.95	133.0128	12130222.0
2011-04-11 10:30:00	SPY	ETF	133.01	133.29	132.9	133.19	7569964.0
2011-04-11 11:00:00	SPY	ETF	133.195	133.32	133.08	133.13	6388842.0
2011-04-11 11:30:00	SPY	ETF	133.14	133.21	132.97	132.98	4595657.0
2011-04-11 12:00:00	SPY	ETF	132.98	133.03	132.82	132.97	6814019.0
2011-04-11 12:30:00	SPY	ETF	132.97	132.98	132.55	132.55	5950097.0
2011-04-11 13:00:00	SPY	ETF	132.5526	132.715	132.48	132.67	6836254.0
2011-04-11 13:30:00	SPY	ETF	132.67	132.72	132.48	132.709	5035449.0
2011-04-11 14:00:00	SPY	ETF	132.71	132.83	132.67	132.73	5060302.0
2011-04-11 14:30:00	SPY	ETF	132.73	132.775	132.355	132.39	7869312.0
2011-04-11 15:00:00	SPY	ETF	132.395	132.42	132.14	132.235	13657840.0
2011-04-11 15:30:00	SPY	ETF	132.22	132.52	132.21	132.47	12479401.0
2011-04-11 16:00:00	SPY	ETF	132.46	133.3104	132.36	132.47	6917756.0
2011-04-11 16:30:00	SPY	ETF	132.47	132.49	132.23	132.3	762325.0
2011-04-11 17:00:00	SPY	ETF	132.29	132.33	132.18	132.2	638261.0
2011-04-11 17:30:00	SPY	ETF	132.16	132.18	132.1	132.18	80726.0
2011-04-11 18:00:00	SPY	ETF	132.17	132.49	132.14	132.25	81217.0
2011-04-11 18:30:00	SPY	ETF	132.26	132.27	132.14	132.17	21790.0
2011-04-11 19:00:00	SPY	ETF	132.16	132.16	132.12	132.14	11190.0
2011-04-11 19:30:00	SPY	ETF	132.16	132.17	132.05	132.15	68696.0
2011-04-11 04:00:00	QQQ	ETF	57.12	57.15	57.02	57.05	3729.0
2011-04-11 04:30:00	QQQ	ETF	57.08	57.08	57.08	57.08	100.0
2011-04-11 06:00:00	QQQ	ETF	57.04	57.07	57.04	57.07	4000.0
2011-04-11 06:30:00	QQQ	ETF	57.06	57.16	57.05	57.16	13100.0
2011-04-11 07:00:00	QQQ	ETF	57.17	57.18	57.15	57.16	23341.0
2011-04-11 07:30:00	QQQ	ETF	57.17	57.17	57.12	57.12	5204.0
2011-04-11 08:00:00	QQQ	ETF	57.12	57.12	57.04	57.11	98545.0
2011-04-11 08:30:00	QQQ	ETF	57.12	57.19	57.11	57.17	168694.0
2011-04-11 09:00:00	QQQ	ETF	57.16	57.18	57.13	57.16	306681.0
2011-04-11 09:30:00	QQQ	ETF	57.16	57.29	57.0	57.01	6795369.0
2011-04-11 10:00:00	QQQ	ETF	57.01	57.07	56.77	56.84	6018941.0
2011-04-11 10:30:00	QQQ	ETF	56.83	57.0	56.77	56.98	3843398.0
2011-04-11 11:00:00	QQQ	ETF	56.98	57.07	56.92	56.92	1834585.0
2011-04-11 11:30:00	QQQ	ETF	56.92	56.95	56.77	56.78	1864356.0
2011-04-11 12:00:00	QQQ	ETF	56.77	56.84	56.7	56.825	2357462.0
2011-04-11 12:30:00	QQQ	ETF	56.825	56.83	56.67	56.68	1882163.0
2011-04-11 13:00:00	QQQ	ETF	56.679	56.79	56.61	56.765	2205321.0
2011-04-11 13:30:00	QQQ	ETF	56.77	56.81	56.671	56.7862	1577027.0

> showing 50 of 9,398 rows — these rows as CSV

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