PREVIEW / etf_30min / 2016-08-19

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-19.parquet
  size:    383 KB
  rows:    13,095

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
2016-08-19 04:00:00	SPY	ETF	218.43	218.43	218.05	218.05	11355.0
2016-08-19 04:30:00	SPY	ETF	218.08	218.12	218.0	218.06	12975.0
2016-08-19 05:00:00	SPY	ETF	218.05	218.22	218.05	218.17	2128.0
2016-08-19 05:30:00	SPY	ETF	218.15	218.23	218.15	218.18	2176.0
2016-08-19 06:00:00	SPY	ETF	218.23	218.37	218.22	218.3	4382.0
2016-08-19 06:30:00	SPY	ETF	218.25	218.3	218.17	218.17	15604.0
2016-08-19 07:00:00	SPY	ETF	218.16	218.27	218.12	218.21	30272.0
2016-08-19 07:30:00	SPY	ETF	218.22	218.25	218.08	218.11	81070.0
2016-08-19 08:00:00	SPY	ETF	218.11	218.22	218.03	218.21	256848.0
2016-08-19 08:30:00	SPY	ETF	218.21	218.3	218.19	218.29	611126.0
2016-08-19 09:00:00	SPY	ETF	218.27	218.38	218.2	218.31	444869.0
2016-08-19 09:30:00	SPY	ETF	218.31	218.35	217.74	217.86	11277510.0
2016-08-19 10:00:00	SPY	ETF	217.855	218.41	217.84	218.4	6880359.0
2016-08-19 10:30:00	SPY	ETF	218.4	218.58	218.31	218.39	7200210.0
2016-08-19 11:00:00	SPY	ETF	218.38	218.53	218.31	218.4999	2076681.0
2016-08-19 11:30:00	SPY	ETF	218.4999	218.5409	218.33	218.5	2007331.0
2016-08-19 12:00:00	SPY	ETF	218.51	218.5925	218.37	218.52	2506689.0
2016-08-19 12:30:00	SPY	ETF	218.52	218.54	218.055	218.122	3141021.0
2016-08-19 13:00:00	SPY	ETF	218.12	218.25	218.08	218.21	2632315.0
2016-08-19 13:30:00	SPY	ETF	218.205	218.42	218.1	218.315	5590124.0
2016-08-19 14:00:00	SPY	ETF	218.32	218.44	218.31	218.4	2528584.0
2016-08-19 14:30:00	SPY	ETF	218.4	218.685	218.38	218.61	4037623.0
2016-08-19 15:00:00	SPY	ETF	218.61	218.74	218.53	218.71	4028050.0
2016-08-19 15:30:00	SPY	ETF	218.705	218.75	218.55	218.57	12303321.0
2016-08-19 16:00:00	SPY	ETF	218.57	218.64	218.53	218.61	3895211.0
2016-08-19 16:30:00	SPY	ETF	218.61	218.67	218.54	218.66	637376.0
2016-08-19 17:00:00	SPY	ETF	218.66	218.75	218.63	218.71	702531.0
2016-08-19 17:30:00	SPY	ETF	218.68	218.7	218.54	218.67	162672.0
2016-08-19 18:00:00	SPY	ETF	218.68	218.68	218.62	218.68	12984.0
2016-08-19 18:30:00	SPY	ETF	218.69	218.7	218.69	218.7	3123.0
2016-08-19 19:00:00	SPY	ETF	218.69	218.69	218.69	218.69	820.0
2016-08-19 19:30:00	SPY	ETF	218.7	218.77	218.69	218.76	20204.0
2016-08-19 04:00:00	QQQ	ETF	117.12	117.12	116.88	116.88	4400.0
2016-08-19 04:30:00	QQQ	ETF	116.88	116.88	116.88	116.88	7600.0
2016-08-19 05:00:00	QQQ	ETF	116.97	116.98	116.97	116.98	200.0
2016-08-19 05:30:00	QQQ	ETF	117.0	117.0	117.0	117.0	200.0
2016-08-19 06:00:00	QQQ	ETF	117.0	117.03	117.0	117.02	2200.0
2016-08-19 06:30:00	QQQ	ETF	117.03	117.03	117.03	117.03	5000.0
2016-08-19 07:00:00	QQQ	ETF	117.02	117.02	116.99	117.01	2217.0
2016-08-19 07:30:00	QQQ	ETF	117.0	117.02	116.94	116.95	10572.0
2016-08-19 08:00:00	QQQ	ETF	116.95	117.02	116.92	117.02	92666.0
2016-08-19 08:30:00	QQQ	ETF	116.99	117.09	116.99	117.07	16483.0
2016-08-19 09:00:00	QQQ	ETF	117.05	117.13	117.02	117.1	115624.0
2016-08-19 09:30:00	QQQ	ETF	117.1	117.13	116.76	116.92	2842882.0
2016-08-19 10:00:00	QQQ	ETF	116.92	117.39	116.8462	117.39	1322551.0
2016-08-19 10:30:00	QQQ	ETF	117.3899	117.52	117.34	117.38	1487171.0
2016-08-19 11:00:00	QQQ	ETF	117.38	117.51	117.34	117.49	670622.0
2016-08-19 11:30:00	QQQ	ETF	117.49	117.51	117.33	117.45	475637.0
2016-08-19 12:00:00	QQQ	ETF	117.4472	117.49	117.305	117.36	602886.0
2016-08-19 12:30:00	QQQ	ETF	117.35	117.36	116.99	117.045	909720.0

> showing 50 of 13,095 rows — these rows as CSV

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