PREVIEW / etf_30min / 2014-03-31

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-31.parquet
  size:    338 KB
  rows:    11,517

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-03-31 04:00:00	SPY	ETF	186.14	186.25	186.14	186.21	2515.0
2014-03-31 04:30:00	SPY	ETF	186.25	186.28	186.22	186.22	40601.0
2014-03-31 05:00:00	SPY	ETF	186.21	186.26	186.11	186.15	9411.0
2014-03-31 05:30:00	SPY	ETF	186.16	186.21	186.16	186.21	5650.0
2014-03-31 06:00:00	SPY	ETF	186.24	186.24	186.02	186.16	33785.0
2014-03-31 06:30:00	SPY	ETF	186.11	186.14	186.02	186.12	155462.0
2014-03-31 07:00:00	SPY	ETF	186.13	186.18	186.08	186.12	144886.0
2014-03-31 07:30:00	SPY	ETF	186.16	186.34	186.14	186.34	198986.0
2014-03-31 08:00:00	SPY	ETF	186.31	186.35	186.13	186.26	178440.0
2014-03-31 08:30:00	SPY	ETF	186.26	186.69	186.26	186.6	631484.0
2014-03-31 09:00:00	SPY	ETF	186.61	186.67	186.53	186.65	900184.0
2014-03-31 09:30:00	SPY	ETF	186.65	187.09	186.6	187.01	16174733.0
2014-03-31 10:00:00	SPY	ETF	187.02	187.18	186.77	186.9899	8357681.0
2014-03-31 10:30:00	SPY	ETF	186.99	187.1	186.85	186.93	5383787.0
2014-03-31 11:00:00	SPY	ETF	186.93	186.94	186.47	186.67	5266801.0
2014-03-31 11:30:00	SPY	ETF	186.66	186.84	186.54	186.79	3313521.0
2014-03-31 12:00:00	SPY	ETF	186.8	187.26	186.79	187.18	5285613.0
2014-03-31 12:30:00	SPY	ETF	187.18	187.3	187.07	187.169	4339106.0
2014-03-31 13:00:00	SPY	ETF	187.17	187.23	186.98	187.08	3556952.0
2014-03-31 13:30:00	SPY	ETF	187.08	187.1	186.69	186.78	4850941.0
2014-03-31 14:00:00	SPY	ETF	186.7737	187.1	186.76	186.9501	3529257.0
2014-03-31 14:30:00	SPY	ETF	186.95	187.15	186.89	187.08	3121398.0
2014-03-31 15:00:00	SPY	ETF	187.08	187.135	186.91	187.08	4653544.0
2014-03-31 15:30:00	SPY	ETF	187.08	187.24	186.89	187.02	17025847.0
2014-03-31 16:00:00	SPY	ETF	187.0	187.04	185.5216	186.85	7404894.0
2014-03-31 16:30:00	SPY	ETF	186.84	187.02	186.81	186.9	3405158.0
2014-03-31 17:00:00	SPY	ETF	186.89	186.9917	186.88	186.91	90199.0
2014-03-31 17:30:00	SPY	ETF	186.92	187.01	186.91	186.96	153961.0
2014-03-31 18:00:00	SPY	ETF	186.96	187.01	186.95	186.98	41815.0
2014-03-31 18:30:00	SPY	ETF	186.98	186.99	186.92	186.93	39422.0
2014-03-31 19:00:00	SPY	ETF	186.95	186.95	186.86	186.87	10089.0
2014-03-31 19:30:00	SPY	ETF	186.86	186.93	186.86	186.92	20661.0
2014-03-31 04:30:00	QQQ	ETF	87.52	87.52	87.52	87.52	500.0
2014-03-31 05:00:00	QQQ	ETF	87.47	87.47	87.41	87.41	2400.0
2014-03-31 06:00:00	QQQ	ETF	87.46	87.46	87.4	87.4	270.0
2014-03-31 06:30:00	QQQ	ETF	87.41	87.43	87.37	87.41	17600.0
2014-03-31 07:00:00	QQQ	ETF	87.42	87.45	87.41	87.45	22000.0
2014-03-31 07:30:00	QQQ	ETF	87.44	87.54	87.44	87.54	111969.0
2014-03-31 08:00:00	QQQ	ETF	87.44	87.55	87.44	87.52	136190.0
2014-03-31 08:30:00	QQQ	ETF	87.51	87.78	87.51	87.76	184405.0
2014-03-31 09:00:00	QQQ	ETF	87.75	87.76	87.67	87.73	221283.0
2014-03-31 09:30:00	QQQ	ETF	87.73	88.09	87.63	88.08	6800074.0
2014-03-31 10:00:00	QQQ	ETF	88.07	88.26	87.92	88.07	3996005.0
2014-03-31 10:30:00	QQQ	ETF	88.07	88.13	87.92	88.01	2050478.0
2014-03-31 11:00:00	QQQ	ETF	88.005	88.02	87.73	87.85	1937346.0
2014-03-31 11:30:00	QQQ	ETF	87.85	88.02	87.75	87.96	1207056.0
2014-03-31 12:00:00	QQQ	ETF	87.95	88.1	87.9299	88.05	1470035.0
2014-03-31 12:30:00	QQQ	ETF	88.0499	88.115	87.96	88.02	996724.0
2014-03-31 13:00:00	QQQ	ETF	88.02	88.05	87.91	87.95	790054.0
2014-03-31 13:30:00	QQQ	ETF	87.94	87.96	87.66	87.7	1064727.0

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

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