PREVIEW / etf_30min / 2014-06-12

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-12.parquet
  size:    340 KB
  rows:    11,374

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-06-12 04:00:00	SPY	ETF	195.11	195.12	195.07	195.1	1229.0
2014-06-12 04:30:00	SPY	ETF	195.15	195.19	195.12	195.19	588.0
2014-06-12 05:00:00	SPY	ETF	195.15	195.17	195.15	195.17	409.0
2014-06-12 05:30:00	SPY	ETF	195.05	195.28	195.05	195.28	4522.0
2014-06-12 06:00:00	SPY	ETF	195.22	195.22	195.12	195.12	7312.0
2014-06-12 06:30:00	SPY	ETF	195.1	195.1	195.01	195.05	26560.0
2014-06-12 07:00:00	SPY	ETF	195.07	195.09	195.03	195.03	9491.0
2014-06-12 07:30:00	SPY	ETF	195.04	195.16	195.04	195.07	119337.0
2014-06-12 08:00:00	SPY	ETF	195.16	195.16	194.95	195.03	210575.0
2014-06-12 08:30:00	SPY	ETF	194.96	194.99	194.56	194.76	728721.0
2014-06-12 09:00:00	SPY	ETF	194.77	194.8	194.6	194.66	716547.0
2014-06-12 09:30:00	SPY	ETF	194.65	194.8	194.41	194.5	8266097.0
2014-06-12 10:00:00	SPY	ETF	194.51	194.7	194.21	194.22	5377457.0
2014-06-12 10:30:00	SPY	ETF	194.22	194.32	194.0	194.15	6813364.0
2014-06-12 11:00:00	SPY	ETF	194.16	194.49	194.085	194.47	5101645.0
2014-06-12 11:30:00	SPY	ETF	194.47	194.48	194.22	194.229	3164079.0
2014-06-12 12:00:00	SPY	ETF	194.2201	194.42	194.12	194.375	2584850.0
2014-06-12 12:30:00	SPY	ETF	194.38	194.385	193.92	194.05	4753124.0
2014-06-12 13:00:00	SPY	ETF	194.051	194.1	193.78	193.84	5395446.0
2014-06-12 13:30:00	SPY	ETF	193.85	193.85	193.35	193.47	8622768.0
2014-06-12 14:00:00	SPY	ETF	193.47	193.69	193.41	193.58	5916382.0
2014-06-12 14:30:00	SPY	ETF	193.58	193.59	193.39	193.46	3837841.0
2014-06-12 15:00:00	SPY	ETF	193.46	193.61	193.21	193.38	6357032.0
2014-06-12 15:30:00	SPY	ETF	193.38	193.65	193.11	193.53	16912921.0
2014-06-12 16:00:00	SPY	ETF	193.53	194.9461	193.5	193.71	9296439.0
2014-06-12 16:30:00	SPY	ETF	193.71	194.9461	193.69	193.76	5361874.0
2014-06-12 17:00:00	SPY	ETF	193.77	193.77	193.7	193.71	68378.0
2014-06-12 17:30:00	SPY	ETF	193.72	193.76	193.7	193.71	6180.0
2014-06-12 18:00:00	SPY	ETF	193.76	193.79	193.7	193.73	45157.0
2014-06-12 18:30:00	SPY	ETF	193.73	193.76	193.6	193.62	23894.0
2014-06-12 19:00:00	SPY	ETF	193.64	193.68	193.58	193.68	66532.0
2014-06-12 19:30:00	SPY	ETF	193.68	193.68	193.49	193.49	88389.0
2014-06-12 04:00:00	QQQ	ETF	92.93	92.93	92.93	92.93	100.0
2014-06-12 06:30:00	QQQ	ETF	92.89	92.89	92.89	92.89	1274.0
2014-06-12 07:30:00	QQQ	ETF	92.91	92.91	92.91	92.91	31600.0
2014-06-12 08:00:00	QQQ	ETF	92.89	92.9	92.84	92.85	24819.0
2014-06-12 08:30:00	QQQ	ETF	92.83	92.84	92.77	92.77	47110.0
2014-06-12 09:00:00	QQQ	ETF	92.75	92.76	92.65	92.69	174653.0
2014-06-12 09:30:00	QQQ	ETF	92.69	92.79	92.49	92.65	3061615.0
2014-06-12 10:00:00	QQQ	ETF	92.64	92.78	92.38	92.38	2387677.0
2014-06-12 10:30:00	QQQ	ETF	92.38	92.5	92.29	92.43	2043205.0
2014-06-12 11:00:00	QQQ	ETF	92.435	92.635	92.38	92.615	1843446.0
2014-06-12 11:30:00	QQQ	ETF	92.615	92.64	92.48	92.485	814697.0
2014-06-12 12:00:00	QQQ	ETF	92.485	92.56	92.46	92.535	865118.0
2014-06-12 12:30:00	QQQ	ETF	92.535	92.54	92.201	92.3195	1373724.0
2014-06-12 13:00:00	QQQ	ETF	92.315	92.34	92.08	92.12	1862695.0
2014-06-12 13:30:00	QQQ	ETF	92.13	92.13	91.89	91.98	1988990.0
2014-06-12 14:00:00	QQQ	ETF	91.97	92.05	91.87	91.975	1673074.0
2014-06-12 14:30:00	QQQ	ETF	91.97	92.02	91.83	91.91	1197420.0
2014-06-12 15:00:00	QQQ	ETF	91.91	91.995	91.761	91.885	1827586.0

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

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