PREVIEW / etf_30min / 2013-09-12

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-12.parquet
  size:    323 KB
  rows:    10,868

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-09-12 04:00:00	SPY	ETF	169.35	169.4	169.25	169.25	7900.0
2013-09-12 04:30:00	SPY	ETF	169.23	169.28	169.23	169.26	1600.0
2013-09-12 05:00:00	SPY	ETF	169.24	169.25	169.12	169.13	12180.0
2013-09-12 05:30:00	SPY	ETF	169.11	169.22	169.11	169.17	6950.0
2013-09-12 06:00:00	SPY	ETF	169.17	169.25	169.13	169.25	18750.0
2013-09-12 06:30:00	SPY	ETF	169.26	169.35	169.26	169.35	59500.0
2013-09-12 07:00:00	SPY	ETF	169.35	169.35	169.25	169.3	17081.0
2013-09-12 07:30:00	SPY	ETF	169.3	169.51	169.3	169.51	98852.0
2013-09-12 08:00:00	SPY	ETF	169.48	169.5	169.3	169.37	175194.0
2013-09-12 08:30:00	SPY	ETF	169.37	169.74	169.23	169.44	441195.0
2013-09-12 09:00:00	SPY	ETF	169.43	169.43	169.27	169.35	593286.0
2013-09-12 09:30:00	SPY	ETF	169.34	169.45	169.07	169.35	10374699.0
2013-09-12 10:00:00	SPY	ETF	169.34	169.49	169.27	169.49	4995908.0
2013-09-12 10:30:00	SPY	ETF	169.485	169.56	169.34	169.34	4753135.0
2013-09-12 11:00:00	SPY	ETF	169.34	169.45	169.1	169.25	5996237.0
2013-09-12 11:30:00	SPY	ETF	169.25	169.31	168.98	169.1	7097469.0
2013-09-12 12:00:00	SPY	ETF	169.105	169.105	168.74	168.87	7957586.0
2013-09-12 12:30:00	SPY	ETF	168.865	169.04	168.85	169.02	3723879.0
2013-09-12 13:00:00	SPY	ETF	169.015	169.31	169.0	169.24	4288583.0
2013-09-12 13:30:00	SPY	ETF	169.235	169.28	169.13	169.13	2967700.0
2013-09-12 14:00:00	SPY	ETF	169.14	169.25	169.08	169.16	3190258.0
2013-09-12 14:30:00	SPY	ETF	169.15	169.23	168.95	169.23	3573459.0
2013-09-12 15:00:00	SPY	ETF	169.2299	169.23	168.82	168.98	7544417.0
2013-09-12 15:30:00	SPY	ETF	168.98	169.0	168.72	168.95	8791658.0
2013-09-12 16:00:00	SPY	ETF	168.94	169.4491	168.94	169.12	3603762.0
2013-09-12 16:30:00	SPY	ETF	169.1	169.13	169.07	169.11	347412.0
2013-09-12 17:00:00	SPY	ETF	169.11	169.13	169.07	169.08	359048.0
2013-09-12 17:30:00	SPY	ETF	169.06	169.11	169.05	169.07	29315.0
2013-09-12 18:00:00	SPY	ETF	169.08	169.14	169.05	169.14	54024.0
2013-09-12 18:30:00	SPY	ETF	169.12	169.14	169.12	169.12	2625.0
2013-09-12 19:00:00	SPY	ETF	169.12	169.13	169.1	169.12	8336.0
2013-09-12 19:30:00	SPY	ETF	169.11	169.14	169.08	169.14	16742.0
2013-09-12 04:00:00	QQQ	ETF	78.06	78.06	78.02	78.02	4300.0
2013-09-12 05:00:00	QQQ	ETF	78.0	78.0	77.96	77.96	3500.0
2013-09-12 05:30:00	QQQ	ETF	77.95	78.0	77.95	78.0	3600.0
2013-09-12 06:00:00	QQQ	ETF	77.98	78.05	77.98	78.05	7900.0
2013-09-12 06:30:00	QQQ	ETF	78.06	78.08	78.06	78.07	3700.0
2013-09-12 07:00:00	QQQ	ETF	78.06	78.08	78.06	78.08	1595.0
2013-09-12 07:30:00	QQQ	ETF	78.1	78.14	78.09	78.14	20860.0
2013-09-12 08:00:00	QQQ	ETF	78.18	78.19	78.07	78.12	48539.0
2013-09-12 08:30:00	QQQ	ETF	78.12	78.16	78.1	78.15	28273.0
2013-09-12 09:00:00	QQQ	ETF	78.13	78.14	78.02	78.05	149901.0
2013-09-12 09:30:00	QQQ	ETF	78.06	78.15	77.85	78.13	2491940.0
2013-09-12 10:00:00	QQQ	ETF	78.1214	78.18	78.07	78.17	1085998.0
2013-09-12 10:30:00	QQQ	ETF	78.18	78.25	78.14	78.145	1450467.0
2013-09-12 11:00:00	QQQ	ETF	78.14	78.24	78.03	78.1391	1179227.0
2013-09-12 11:30:00	QQQ	ETF	78.13	78.16	77.92	78.0795	1270305.0
2013-09-12 12:00:00	QQQ	ETF	78.07	78.07	77.94	78.01	884624.0
2013-09-12 12:30:00	QQQ	ETF	78.02	78.1	78.005	78.05	1013389.0
2013-09-12 13:00:00	QQQ	ETF	78.05	78.21	78.05	78.17	1020008.0

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

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