PREVIEW / etf_30min / 2014-10-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-21.parquet
  size:    382 KB
  rows:    12,666

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-10-21 04:00:00	SPY	ETF	190.36	190.63	190.36	190.49	3412.0
2014-10-21 04:30:00	SPY	ETF	190.56	190.81	190.56	190.78	9885.0
2014-10-21 05:00:00	SPY	ETF	190.7	190.72	190.45	190.6	21571.0
2014-10-21 05:30:00	SPY	ETF	190.69	191.23	190.69	191.07	64071.0
2014-10-21 06:00:00	SPY	ETF	191.1	191.83	191.09	191.74	198118.0
2014-10-21 06:30:00	SPY	ETF	191.73	192.2	191.58	192.05	299843.0
2014-10-21 07:00:00	SPY	ETF	192.07	192.18	191.82	191.99	644451.0
2014-10-21 07:30:00	SPY	ETF	191.98	192.0	191.28	191.44	1009538.0
2014-10-21 08:00:00	SPY	ETF	191.42	192.18	191.23	191.39	1107436.0
2014-10-21 08:30:00	SPY	ETF	191.37	191.85	191.31	191.85	913373.0
2014-10-21 09:00:00	SPY	ETF	191.82	191.84	191.6	191.66	1411578.0
2014-10-21 09:30:00	SPY	ETF	191.68	192.36	191.48	192.157	19697679.0
2014-10-21 10:00:00	SPY	ETF	192.16	192.51	192.0	192.36	15460287.0
2014-10-21 10:30:00	SPY	ETF	192.37	192.77	192.34	192.6	10166483.0
2014-10-21 11:00:00	SPY	ETF	192.595	192.93	192.55	192.9267	10609540.0
2014-10-21 11:30:00	SPY	ETF	192.93	193.33	192.87	193.22	11228683.0
2014-10-21 12:00:00	SPY	ETF	193.215	193.39	193.19	193.28	6592846.0
2014-10-21 12:30:00	SPY	ETF	193.28	193.32	192.93	193.02	6976448.0
2014-10-21 13:00:00	SPY	ETF	193.01	193.08	192.85	193.05	5272264.0
2014-10-21 13:30:00	SPY	ETF	193.05	193.54	193.04	193.45	7787233.0
2014-10-21 14:00:00	SPY	ETF	193.45	193.67	193.35	193.56	6526826.0
2014-10-21 14:30:00	SPY	ETF	193.56	193.75	193.44	193.57	6849478.0
2014-10-21 15:00:00	SPY	ETF	193.57	194.2	193.52	194.16	9569858.0
2014-10-21 15:30:00	SPY	ETF	194.155	194.16	193.75	194.05	20865918.0
2014-10-21 16:00:00	SPY	ETF	194.05	194.46	193.2398	194.42	5805694.0
2014-10-21 16:30:00	SPY	ETF	194.43	194.51	194.05	194.5	3488497.0
2014-10-21 17:00:00	SPY	ETF	194.47	194.54	194.43	194.45	170280.0
2014-10-21 17:30:00	SPY	ETF	194.45	194.49	194.07	194.4	1138615.0
2014-10-21 18:00:00	SPY	ETF	194.4	194.41	194.3299	194.33	123846.0
2014-10-21 18:30:00	SPY	ETF	194.34	194.36	194.23	194.26	56900.0
2014-10-21 19:00:00	SPY	ETF	194.26	194.29	194.2	194.23	79118.0
2014-10-21 19:30:00	SPY	ETF	194.23	194.26	194.19	194.26	188797.0
2014-10-21 04:00:00	QQQ	ETF	94.69	94.69	94.63	94.63	1300.0
2014-10-21 05:30:00	QQQ	ETF	94.8	95.02	94.72	94.96	25100.0
2014-10-21 06:00:00	QQQ	ETF	94.98	95.28	94.98	95.28	56500.0
2014-10-21 06:30:00	QQQ	ETF	95.25	95.47	95.15	95.39	21000.0
2014-10-21 07:00:00	QQQ	ETF	95.45	95.47	95.27	95.33	108190.0
2014-10-21 07:30:00	QQQ	ETF	95.35	95.4	95.04	95.15	223830.0
2014-10-21 08:00:00	QQQ	ETF	95.12	95.44	95.08	95.2	231758.0
2014-10-21 08:30:00	QQQ	ETF	95.22	95.45	95.15	95.44	162096.0
2014-10-21 09:00:00	QQQ	ETF	95.43	95.57	95.38	95.54	582732.0
2014-10-21 09:30:00	QQQ	ETF	95.54	95.72	95.32	95.63	6823077.0
2014-10-21 10:00:00	QQQ	ETF	95.63	95.8	95.48	95.74	4775015.0
2014-10-21 10:30:00	QQQ	ETF	95.74	95.96	95.73	95.9398	2824934.0
2014-10-21 11:00:00	QQQ	ETF	95.939	96.13	95.91	96.1131	2939176.0
2014-10-21 11:30:00	QQQ	ETF	96.11	96.27	96.095	96.17	2657769.0
2014-10-21 12:00:00	QQQ	ETF	96.165	96.3099	96.15	96.25	1487148.0
2014-10-21 12:30:00	QQQ	ETF	96.25	96.26	96.12	96.15	1706706.0
2014-10-21 13:00:00	QQQ	ETF	96.15	96.22	96.08	96.18	1866828.0
2014-10-21 13:30:00	QQQ	ETF	96.189	96.54	96.189	96.47	3658703.0

> showing 50 of 12,666 rows — these rows as CSV

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