PREVIEW / etf_30min / 2013-03-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-25.parquet
  size:    317 KB
  rows:    10,553

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-25 04:00:00	SPY	ETF	155.99	156.18	155.99	156.13	2050.0
2013-03-25 04:30:00	SPY	ETF	156.07	156.2	156.07	156.17	6100.0
2013-03-25 05:00:00	SPY	ETF	156.17	156.3	156.17	156.25	12575.0
2013-03-25 05:30:00	SPY	ETF	156.31	156.45	156.31	156.45	99175.0
2013-03-25 06:00:00	SPY	ETF	156.45	156.47	156.42	156.45	16200.0
2013-03-25 06:30:00	SPY	ETF	156.43	156.43	156.26	156.27	107728.0
2013-03-25 07:00:00	SPY	ETF	156.27	156.3	156.17	156.25	91757.0
2013-03-25 07:30:00	SPY	ETF	156.25	156.31	156.23	156.28	289560.0
2013-03-25 08:00:00	SPY	ETF	156.28	156.3	156.15	156.19	266273.0
2013-03-25 08:30:00	SPY	ETF	156.2	156.23	155.94	155.96	532150.0
2013-03-25 09:00:00	SPY	ETF	155.96	156.07	155.84	156.0	861497.0
2013-03-25 09:30:00	SPY	ETF	156.01	156.25	155.81	156.23	10944792.0
2013-03-25 10:00:00	SPY	ETF	156.23	156.27	155.8	155.85	7460595.0
2013-03-25 10:30:00	SPY	ETF	155.85	155.92	155.26	155.3	8939998.0
2013-03-25 11:00:00	SPY	ETF	155.3	155.41	154.8	154.95	11812888.0
2013-03-25 11:30:00	SPY	ETF	154.94	155.305	154.89	155.169	10626456.0
2013-03-25 12:00:00	SPY	ETF	155.17	155.4555	154.84	154.84	9654058.0
2013-03-25 12:30:00	SPY	ETF	154.85	154.98	154.6	154.64	7526183.0
2013-03-25 13:00:00	SPY	ETF	154.64	154.82	154.35	154.77	13534127.0
2013-03-25 13:30:00	SPY	ETF	154.78	155.38	154.58	155.2	10703747.0
2013-03-25 14:00:00	SPY	ETF	155.198	155.34	155.03	155.1	7454036.0
2013-03-25 14:30:00	SPY	ETF	155.0991	155.11	154.88	155.04	5778732.0
2013-03-25 15:00:00	SPY	ETF	155.04	155.05	154.56	154.635	11470555.0
2013-03-25 15:30:00	SPY	ETF	154.64	155.15	154.63	155.0	17406407.0
2013-03-25 16:00:00	SPY	ETF	154.99	156.0444	154.85	155.12	10273406.0
2013-03-25 16:30:00	SPY	ETF	155.13	155.24	155.13	155.24	1202830.0
2013-03-25 17:00:00	SPY	ETF	155.24	155.29	155.17	155.24	140760.0
2013-03-25 17:30:00	SPY	ETF	155.26	155.26	155.22	155.25	45483.0
2013-03-25 18:00:00	SPY	ETF	155.26	155.26	155.1	155.17	90017.0
2013-03-25 18:30:00	SPY	ETF	155.18	155.25	155.17	155.24	19070.0
2013-03-25 19:00:00	SPY	ETF	155.22	155.25	155.22	155.22	28135.0
2013-03-25 19:30:00	SPY	ETF	155.24	155.27	155.24	155.24	44638.0
2013-03-25 04:00:00	QQQ	ETF	68.8	68.81	68.8	68.8	682.0
2013-03-25 05:00:00	QQQ	ETF	68.84	68.89	68.84	68.89	740.0
2013-03-25 05:30:00	QQQ	ETF	68.9	68.9	68.9	68.9	600.0
2013-03-25 06:00:00	QQQ	ETF	68.95	68.95	68.95	68.95	7000.0
2013-03-25 06:30:00	QQQ	ETF	68.93	68.96	68.9	68.9	2400.0
2013-03-25 07:00:00	QQQ	ETF	68.87	68.9	68.87	68.9	3700.0
2013-03-25 07:30:00	QQQ	ETF	68.91	68.91	68.89	68.89	7260.0
2013-03-25 08:00:00	QQQ	ETF	68.88	68.92	68.87	68.87	33641.0
2013-03-25 08:30:00	QQQ	ETF	68.86	68.89	68.8	68.8	23541.0
2013-03-25 09:00:00	QQQ	ETF	68.78	68.81	68.75	68.81	66722.0
2013-03-25 09:30:00	QQQ	ETF	68.81	68.86	68.71	68.86	1920549.0
2013-03-25 10:00:00	QQQ	ETF	68.85	68.96	68.64	68.6997	1635599.0
2013-03-25 10:30:00	QQQ	ETF	68.69	68.73	68.4164	68.42	1611957.0
2013-03-25 11:00:00	QQQ	ETF	68.42	68.445	68.13	68.21	2983982.0
2013-03-25 11:30:00	QQQ	ETF	68.21	68.39	68.19	68.32	1432774.0
2013-03-25 12:00:00	QQQ	ETF	68.32	68.38	68.18	68.19	1196757.0
2013-03-25 12:30:00	QQQ	ETF	68.18	68.28	68.111	68.16	1236783.0
2013-03-25 13:00:00	QQQ	ETF	68.13	68.26	68.01	68.24	2022359.0

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

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