PREVIEW / etf_30min / 2014-05-15

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-15.parquet
  size:    343 KB
  rows:    11,579

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-05-15 04:00:00	SPY	ETF	189.16	189.16	188.93	188.93	600.0
2014-05-15 04:30:00	SPY	ETF	188.9	188.94	188.85	188.94	11190.0
2014-05-15 05:00:00	SPY	ETF	188.94	189.02	188.94	189.02	1300.0
2014-05-15 05:30:00	SPY	ETF	189.0	189.0	188.88	188.92	10012.0
2014-05-15 06:00:00	SPY	ETF	188.88	188.96	188.84	188.88	12862.0
2014-05-15 06:30:00	SPY	ETF	188.91	189.04	188.9	188.96	6105.0
2014-05-15 07:00:00	SPY	ETF	188.96	188.96	188.79	188.81	233775.0
2014-05-15 07:30:00	SPY	ETF	188.79	188.82	188.67	188.78	217241.0
2014-05-15 08:00:00	SPY	ETF	188.82	188.85	188.67	188.8	188409.0
2014-05-15 08:30:00	SPY	ETF	188.85	189.03	188.69	188.82	1236432.0
2014-05-15 09:00:00	SPY	ETF	188.82	188.82	188.54	188.67	718373.0
2014-05-15 09:30:00	SPY	ETF	188.67	188.72	187.62	187.97	16158699.0
2014-05-15 10:00:00	SPY	ETF	187.97	187.98	187.02	187.32	27687433.0
2014-05-15 10:30:00	SPY	ETF	187.31	187.48	186.99	187.24	9373489.0
2014-05-15 11:00:00	SPY	ETF	187.25	187.34	186.65	186.68	10465288.0
2014-05-15 11:30:00	SPY	ETF	186.69	187.16	186.48	186.57	9123248.0
2014-05-15 12:00:00	SPY	ETF	186.57	186.86	186.53	186.68	7078089.0
2014-05-15 12:30:00	SPY	ETF	186.68	187.07	186.65	187.02	4894245.0
2014-05-15 13:00:00	SPY	ETF	187.02	187.051	186.77	186.85	5460066.0
2014-05-15 13:30:00	SPY	ETF	186.85	186.97	186.63	186.97	6737547.0
2014-05-15 14:00:00	SPY	ETF	186.97	187.29	186.821	187.08	11574302.0
2014-05-15 14:30:00	SPY	ETF	187.08	187.45	187.07	187.34	9733960.0
2014-05-15 15:00:00	SPY	ETF	187.34	187.43	187.01	187.15	8318183.0
2014-05-15 15:30:00	SPY	ETF	187.16	187.54	187.08	187.38	15017819.0
2014-05-15 16:00:00	SPY	ETF	187.38	189.1194	187.14	187.34	7956528.0
2014-05-15 16:30:00	SPY	ETF	187.34	187.355	187.24	187.29	1690018.0
2014-05-15 17:00:00	SPY	ETF	187.28	187.3	187.23	187.26	74820.0
2014-05-15 17:30:00	SPY	ETF	187.26	187.29	187.24	187.29	31881.0
2014-05-15 18:00:00	SPY	ETF	187.3	187.4	187.3	187.35	22825.0
2014-05-15 18:30:00	SPY	ETF	187.35	187.36	187.26	187.26	23642.0
2014-05-15 19:00:00	SPY	ETF	187.3	187.31	187.29	187.29	2802.0
2014-05-15 19:30:00	SPY	ETF	187.33	187.35	187.3	187.33	7995.0
2014-05-15 04:00:00	QQQ	ETF	87.84	87.84	87.84	87.84	160.0
2014-05-15 05:00:00	QQQ	ETF	88.0	88.03	88.0	88.03	4700.0
2014-05-15 06:00:00	QQQ	ETF	87.95	87.95	87.94	87.94	1100.0
2014-05-15 06:30:00	QQQ	ETF	88.01	88.01	88.01	88.01	1000.0
2014-05-15 07:00:00	QQQ	ETF	87.94	87.97	87.85	87.86	16454.0
2014-05-15 07:30:00	QQQ	ETF	87.87	87.87	87.75	87.84	36210.0
2014-05-15 08:00:00	QQQ	ETF	87.95	87.95	87.77	87.88	71433.0
2014-05-15 08:30:00	QQQ	ETF	87.87	87.99	87.81	87.84	176494.0
2014-05-15 09:00:00	QQQ	ETF	87.86	87.9	87.73	87.82	483968.0
2014-05-15 09:30:00	QQQ	ETF	87.81	87.96	87.2	87.46	7982161.0
2014-05-15 10:00:00	QQQ	ETF	87.45	87.47	86.73	87.03	8248074.0
2014-05-15 10:30:00	QQQ	ETF	87.03	87.2	86.87	87.04	3380372.0
2014-05-15 11:00:00	QQQ	ETF	87.04	87.09	86.76	86.81	2764260.0
2014-05-15 11:30:00	QQQ	ETF	86.79	87.02	86.58	86.65	2492965.0
2014-05-15 12:00:00	QQQ	ETF	86.65	86.82	86.6301	86.74	2113631.0
2014-05-15 12:30:00	QQQ	ETF	86.74	86.98	86.71	86.92	1982525.0
2014-05-15 13:00:00	QQQ	ETF	86.929	86.97	86.8	86.91	1350683.0
2014-05-15 13:30:00	QQQ	ETF	86.92	86.95	86.75	86.93	1892443.0

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

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