PREVIEW / etf_30min / 2014-09-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-24.parquet
  size:    352 KB
  rows:    11,830

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
2014-09-24 04:00:00	SPY	ETF	198.01	198.09	198.0	198.01	2649.0
2014-09-24 04:30:00	SPY	ETF	197.97	198.0	197.89	197.95	5830.0
2014-09-24 05:00:00	SPY	ETF	197.98	198.03	197.95	198.0	2058.0
2014-09-24 05:30:00	SPY	ETF	197.97	197.97	197.96	197.96	3261.0
2014-09-24 06:00:00	SPY	ETF	197.97	198.16	197.97	198.16	13465.0
2014-09-24 06:30:00	SPY	ETF	198.19	198.32	198.17	198.17	58632.0
2014-09-24 07:00:00	SPY	ETF	198.16	198.24	198.11	198.19	163841.0
2014-09-24 07:30:00	SPY	ETF	198.18	198.25	198.14	198.17	164958.0
2014-09-24 08:00:00	SPY	ETF	198.16	198.27	198.16	198.24	228945.0
2014-09-24 08:30:00	SPY	ETF	198.23	198.23	198.03	198.04	320176.0
2014-09-24 09:00:00	SPY	ETF	198.05	198.08	197.93	198.05	838690.0
2014-09-24 09:30:00	SPY	ETF	198.04	198.35	197.7227	197.91	11219041.0
2014-09-24 10:00:00	SPY	ETF	197.91	198.055	197.52	197.91	10692724.0
2014-09-24 10:30:00	SPY	ETF	197.91	198.31	197.84	198.16	6840487.0
2014-09-24 11:00:00	SPY	ETF	198.16	198.9	198.11	198.88	7466866.0
2014-09-24 11:30:00	SPY	ETF	198.88	199.03	198.78	198.9	6934722.0
2014-09-24 12:00:00	SPY	ETF	198.91	198.96	198.68	198.83	3522212.0
2014-09-24 12:30:00	SPY	ETF	198.83	198.85	198.63	198.73	3375232.0
2014-09-24 13:00:00	SPY	ETF	198.735	198.91	198.68	198.82	4701294.0
2014-09-24 13:30:00	SPY	ETF	198.81	199.18	198.81	199.1	5994140.0
2014-09-24 14:00:00	SPY	ETF	199.1	199.42	199.03	199.36	4371339.0
2014-09-24 14:30:00	SPY	ETF	199.37	199.55	199.29	199.51	6940405.0
2014-09-24 15:00:00	SPY	ETF	199.52	199.69	199.48	199.58	7083342.0
2014-09-24 15:30:00	SPY	ETF	199.57	199.67	199.44	199.57	15526880.0
2014-09-24 16:00:00	SPY	ETF	199.57	199.59	197.9603	199.52	8252567.0
2014-09-24 16:30:00	SPY	ETF	199.52	199.56	199.48	199.5	600733.0
2014-09-24 17:00:00	SPY	ETF	199.5	199.53	199.46	199.5	82677.0
2014-09-24 17:30:00	SPY	ETF	199.48	199.6	199.48	199.54	73586.0
2014-09-24 18:00:00	SPY	ETF	199.51	199.54	199.49	199.51	42625.0
2014-09-24 18:30:00	SPY	ETF	199.5	199.57	199.49	199.55	14238.0
2014-09-24 19:00:00	SPY	ETF	199.55	199.57	199.54	199.54	24475.0
2014-09-24 19:30:00	SPY	ETF	199.57	199.57	199.54	199.57	33829.0
2014-09-24 04:00:00	QQQ	ETF	98.74	98.74	98.74	98.74	2500.0
2014-09-24 05:00:00	QQQ	ETF	98.8	98.8	98.8	98.8	300.0
2014-09-24 05:30:00	QQQ	ETF	98.82	98.82	98.76	98.76	1600.0
2014-09-24 06:00:00	QQQ	ETF	98.8	98.86	98.8	98.86	3600.0
2014-09-24 06:30:00	QQQ	ETF	98.88	99.03	98.88	98.95	15400.0
2014-09-24 07:00:00	QQQ	ETF	98.89	98.95	98.88	98.9	15150.0
2014-09-24 07:30:00	QQQ	ETF	98.91	98.94	98.88	98.91	18300.0
2014-09-24 08:00:00	QQQ	ETF	98.91	98.95	98.89	98.94	28450.0
2014-09-24 08:30:00	QQQ	ETF	98.93	98.93	98.84	98.84	47518.0
2014-09-24 09:00:00	QQQ	ETF	98.83	98.87	98.77	98.86	318882.0
2014-09-24 09:30:00	QQQ	ETF	98.87	99.15	98.71	98.89	4093412.0
2014-09-24 10:00:00	QQQ	ETF	98.87	98.94	98.54	98.85	4006903.0
2014-09-24 10:30:00	QQQ	ETF	98.86	99.04	98.79	98.92	1974349.0
2014-09-24 11:00:00	QQQ	ETF	98.93	99.48	98.905	99.47	2984493.0
2014-09-24 11:30:00	QQQ	ETF	99.47	99.55	99.44	99.52	1764557.0
2014-09-24 12:00:00	QQQ	ETF	99.525	99.54	99.36	99.47	1534540.0
2014-09-24 12:30:00	QQQ	ETF	99.47	99.495	99.35	99.3866	1104111.0
2014-09-24 13:00:00	QQQ	ETF	99.38	99.52	99.36	99.507	1374443.0

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

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