PREVIEW / etf_30min / 2013-10-28

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-28.parquet
  size:    319 KB
  rows:    11,161

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-10-28 04:00:00	SPY	ETF	175.89	176.35	175.79	176.32	42932.0
2013-10-28 04:30:00	SPY	ETF	176.28	176.28	176.22	176.24	3200.0
2013-10-28 05:00:00	SPY	ETF	176.26	176.3	176.26	176.3	500.0
2013-10-28 05:30:00	SPY	ETF	176.28	176.3	176.24	176.28	4919.0
2013-10-28 06:00:00	SPY	ETF	176.28	176.32	176.21	176.22	7818.0
2013-10-28 06:30:00	SPY	ETF	176.24	176.24	176.09	176.09	120100.0
2013-10-28 07:00:00	SPY	ETF	176.08	176.14	176.06	176.09	86849.0
2013-10-28 07:30:00	SPY	ETF	176.1	176.1	175.97	176.05	125958.0
2013-10-28 08:00:00	SPY	ETF	175.93	176.06	175.67	175.75	541614.0
2013-10-28 08:30:00	SPY	ETF	175.74	175.82	175.72	175.81	164979.0
2013-10-28 09:00:00	SPY	ETF	175.81	175.9	175.79	175.88	2003475.0
2013-10-28 09:30:00	SPY	ETF	175.89	176.065	175.72	175.93	8913807.0
2013-10-28 10:00:00	SPY	ETF	175.93	176.27	175.82	176.11	6315533.0
2013-10-28 10:30:00	SPY	ETF	176.11	176.13	175.7	175.77	6077539.0
2013-10-28 11:00:00	SPY	ETF	175.78	175.99	175.71	175.9761	4351887.0
2013-10-28 11:30:00	SPY	ETF	175.98	176.12	175.89	176.1	4004316.0
2013-10-28 12:00:00	SPY	ETF	176.09	176.22	176.06	176.19	3073702.0
2013-10-28 12:30:00	SPY	ETF	176.19	176.38	176.09	176.34	3335538.0
2013-10-28 13:00:00	SPY	ETF	176.34	176.38	176.25	176.29	2280463.0
2013-10-28 13:30:00	SPY	ETF	176.295	176.35	176.21	176.265	2281881.0
2013-10-28 14:00:00	SPY	ETF	176.27	176.45	176.21	176.41	2913435.0
2013-10-28 14:30:00	SPY	ETF	176.42	176.47	176.37	176.42	3160302.0
2013-10-28 15:00:00	SPY	ETF	176.43	176.43	176.155	176.195	5379520.0
2013-10-28 15:30:00	SPY	ETF	176.195	176.25	175.92	176.21	17156384.0
2013-10-28 16:00:00	SPY	ETF	176.22	176.45	176.1712	176.43	4597182.0
2013-10-28 16:30:00	SPY	ETF	176.45	176.48	175.937	176.25	3241022.0
2013-10-28 17:00:00	SPY	ETF	176.25	176.33	176.21	176.3	89442.0
2013-10-28 17:30:00	SPY	ETF	176.32	176.43	176.3	176.4	85513.0
2013-10-28 18:00:00	SPY	ETF	176.37	176.37	176.22	176.29	67008.0
2013-10-28 18:30:00	SPY	ETF	176.28	176.36	176.11	176.18	98661.0
2013-10-28 19:00:00	SPY	ETF	176.16	176.17	176.13	176.16	47420.0
2013-10-28 19:30:00	SPY	ETF	176.16	176.19	176.1	176.16	34253.0
2013-10-28 04:00:00	QQQ	ETF	83.1	83.1	83.03	83.06	23000.0
2013-10-28 04:30:00	QQQ	ETF	83.05	83.08	83.02	83.05	6880.0
2013-10-28 05:00:00	QQQ	ETF	83.06	83.11	83.06	83.11	3400.0
2013-10-28 05:30:00	QQQ	ETF	83.12	83.13	83.11	83.12	7000.0
2013-10-28 06:00:00	QQQ	ETF	83.13	83.14	83.05	83.05	6600.0
2013-10-28 06:30:00	QQQ	ETF	83.05	83.05	83.01	83.01	11465.0
2013-10-28 07:00:00	QQQ	ETF	83.02	83.02	82.99	83.0	4900.0
2013-10-28 07:30:00	QQQ	ETF	83.0	83.0	82.94	83.0	22525.0
2013-10-28 08:00:00	QQQ	ETF	83.0	83.01	82.82	82.83	81493.0
2013-10-28 08:30:00	QQQ	ETF	82.84	82.88	82.84	82.88	46990.0
2013-10-28 09:00:00	QQQ	ETF	82.89	82.91	82.86	82.9	48300.0
2013-10-28 09:30:00	QQQ	ETF	82.9	82.95	82.71	82.8	3388340.0
2013-10-28 10:00:00	QQQ	ETF	82.79	82.97	82.74	82.81	1997101.0
2013-10-28 10:30:00	QQQ	ETF	82.815	82.815	82.55	82.62	2099647.0
2013-10-28 11:00:00	QQQ	ETF	82.61	82.74	82.56	82.73	1426913.0
2013-10-28 11:30:00	QQQ	ETF	82.74	82.79	82.67	82.76	921410.0
2013-10-28 12:00:00	QQQ	ETF	82.76	82.89	82.74	82.89	1039455.0
2013-10-28 12:30:00	QQQ	ETF	82.89	83.019	82.85	82.99	1323800.0

> showing 50 of 11,161 rows — these rows as CSV

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