PREVIEW / etf_30min / 2013-03-21

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-21.parquet
  size:    307 KB
  rows:    10,380

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
2013-03-21 04:00:00	SPY	ETF	155.4	155.42	155.23	155.28	33490.0
2013-03-21 04:30:00	SPY	ETF	155.12	155.12	155.02	155.02	10691.0
2013-03-21 05:00:00	SPY	ETF	155.24	155.24	155.17	155.17	1200.0
2013-03-21 05:30:00	SPY	ETF	155.19	155.24	155.11	155.15	5600.0
2013-03-21 06:00:00	SPY	ETF	155.09	155.14	155.0	155.14	1750.0
2013-03-21 06:30:00	SPY	ETF	155.1	155.21	155.1	155.21	10900.0
2013-03-21 07:00:00	SPY	ETF	155.21	155.39	155.2	155.25	116640.0
2013-03-21 07:30:00	SPY	ETF	155.27	155.38	155.23	155.31	243120.0
2013-03-21 08:00:00	SPY	ETF	155.31	155.44	155.25	155.44	359045.0
2013-03-21 08:30:00	SPY	ETF	155.42	155.43	155.14	155.18	475071.0
2013-03-21 09:00:00	SPY	ETF	155.16	155.26	154.7	154.76	1175905.0
2013-03-21 09:30:00	SPY	ETF	154.76	155.17	154.7	155.12	11384545.0
2013-03-21 10:00:00	SPY	ETF	155.12	155.2	154.57	154.76	10525230.0
2013-03-21 10:30:00	SPY	ETF	154.77	154.87	154.59	154.86	7253823.0
2013-03-21 11:00:00	SPY	ETF	154.87	155.12	154.68	155.01	6335070.0
2013-03-21 11:30:00	SPY	ETF	155.02	155.31	154.98	155.16	7003782.0
2013-03-21 12:00:00	SPY	ETF	155.16	155.22	154.95	155.01	5184421.0
2013-03-21 12:30:00	SPY	ETF	155.01	155.14	154.93	155.002	4577346.0
2013-03-21 13:00:00	SPY	ETF	155.0	155.095	154.63	154.71	6558331.0
2013-03-21 13:30:00	SPY	ETF	154.715	154.72	154.45	154.552	11466823.0
2013-03-21 14:00:00	SPY	ETF	154.55	154.77	154.1	154.615	14624649.0
2013-03-21 14:30:00	SPY	ETF	154.62	154.73	154.49	154.6829	5396885.0
2013-03-21 15:00:00	SPY	ETF	154.688	155.14	154.48	154.73	7710847.0
2013-03-21 15:30:00	SPY	ETF	154.74	155.6389	154.33	154.36	18848191.0
2013-03-21 16:00:00	SPY	ETF	154.36	154.86	154.3	154.41	5591991.0
2013-03-21 16:30:00	SPY	ETF	154.41	154.46	154.32	154.37	656938.0
2013-03-21 17:00:00	SPY	ETF	154.4	154.41	154.29	154.34	78184.0
2013-03-21 17:30:00	SPY	ETF	154.34	154.37	154.31	154.31	52930.0
2013-03-21 18:00:00	SPY	ETF	154.31	154.31	154.23	154.25	75871.0
2013-03-21 18:30:00	SPY	ETF	154.25	154.26	154.21	154.22	41500.0
2013-03-21 19:00:00	SPY	ETF	154.25	154.27	154.23	154.27	9200.0
2013-03-21 19:30:00	SPY	ETF	154.27	154.34	154.26	154.34	53947.0
2013-03-21 04:00:00	QQQ	ETF	68.35	68.4	68.35	68.4	4900.0
2013-03-21 04:30:00	QQQ	ETF	68.22	68.22	68.15	68.15	1340.0
2013-03-21 05:00:00	QQQ	ETF	68.19	68.19	68.19	68.19	200.0
2013-03-21 06:00:00	QQQ	ETF	68.16	68.16	68.16	68.16	100.0
2013-03-21 06:30:00	QQQ	ETF	68.21	68.24	68.2	68.23	16400.0
2013-03-21 07:00:00	QQQ	ETF	68.25	68.3	68.25	68.3	41000.0
2013-03-21 07:30:00	QQQ	ETF	68.31	68.34	68.3	68.3	12500.0
2013-03-21 08:00:00	QQQ	ETF	68.32	68.32	68.26	68.31	29650.0
2013-03-21 08:30:00	QQQ	ETF	68.31	68.31	68.17	68.19	154717.0
2013-03-21 09:00:00	QQQ	ETF	68.18	68.22	68.05	68.09	343738.0
2013-03-21 09:30:00	QQQ	ETF	68.09	68.23	68.04	68.19	3631412.0
2013-03-21 10:00:00	QQQ	ETF	68.2	68.2199	67.92	68.01	3428283.0
2013-03-21 10:30:00	QQQ	ETF	68.0131	68.09	67.97	68.02	1371150.0
2013-03-21 11:00:00	QQQ	ETF	68.0201	68.158	67.95	68.11	1617353.0
2013-03-21 11:30:00	QQQ	ETF	68.11	68.22	68.09	68.17	804790.0
2013-03-21 12:00:00	QQQ	ETF	68.165	68.21	68.07	68.1	1070911.0
2013-03-21 12:30:00	QQQ	ETF	68.11	68.25	68.08	68.19	1412079.0
2013-03-21 13:00:00	QQQ	ETF	68.19	68.24	68.03	68.052	1250369.0

> showing 50 of 10,380 rows — these rows as CSV

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