PREVIEW / etf_30min / 2015-08-07

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-07.parquet
  size:    370 KB
  rows:    12,379

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
2015-08-07 04:00:00	SPY	ETF	208.52	208.52	208.33	208.48	7150.0
2015-08-07 04:30:00	SPY	ETF	208.54	208.69	208.54	208.63	4810.0
2015-08-07 05:00:00	SPY	ETF	208.68	208.68	208.38	208.43	1300.0
2015-08-07 05:30:00	SPY	ETF	208.39	208.39	208.31	208.34	4700.0
2015-08-07 06:00:00	SPY	ETF	208.29	208.3	208.27	208.27	4620.0
2015-08-07 06:30:00	SPY	ETF	208.43	208.43	208.35	208.35	6800.0
2015-08-07 07:00:00	SPY	ETF	208.38	208.38	208.25	208.38	43600.0
2015-08-07 07:30:00	SPY	ETF	208.37	208.43	208.07	208.18	175660.0
2015-08-07 08:00:00	SPY	ETF	208.18	208.32	208.13	208.29	212319.0
2015-08-07 08:30:00	SPY	ETF	208.29	208.85	207.76	208.85	2807777.0
2015-08-07 09:00:00	SPY	ETF	208.85	208.9	208.09	208.16	1124828.0
2015-08-07 09:30:00	SPY	ETF	208.16	208.34	207.68	208.21	15245620.0
2015-08-07 10:00:00	SPY	ETF	208.23	208.23	207.4	207.53	7684150.0
2015-08-07 10:30:00	SPY	ETF	207.53	208.08	207.43	207.645	6477505.0
2015-08-07 11:00:00	SPY	ETF	207.66	207.8	207.05	207.2	8767172.0
2015-08-07 11:30:00	SPY	ETF	207.19	207.32	206.95	207.27	7503481.0
2015-08-07 12:00:00	SPY	ETF	207.28	207.45	207.16	207.27	4242573.0
2015-08-07 12:30:00	SPY	ETF	207.25	207.33	206.98	207.19	3389448.0
2015-08-07 13:00:00	SPY	ETF	207.185	207.19	206.87	207.01	4812370.0
2015-08-07 13:30:00	SPY	ETF	207.0	207.345	207.0	207.1675	4654931.0
2015-08-07 14:00:00	SPY	ETF	207.16	207.26	206.97	207.15	3260817.0
2015-08-07 14:30:00	SPY	ETF	207.15	207.44	207.15	207.39	4446013.0
2015-08-07 15:00:00	SPY	ETF	207.39	207.84	207.1375	207.75	10531710.0
2015-08-07 15:30:00	SPY	ETF	207.75	207.94	207.62	207.93	19128097.0
2015-08-07 16:00:00	SPY	ETF	207.92	208.05	207.65	208.0	5000677.0
2015-08-07 16:30:00	SPY	ETF	207.98	208.02	207.87	207.97	6545636.0
2015-08-07 17:00:00	SPY	ETF	207.97	208.03	207.92	208.03	579948.0
2015-08-07 17:30:00	SPY	ETF	208.02	208.04	207.57	207.93	236250.0
2015-08-07 18:00:00	SPY	ETF	207.93	207.93	207.92	207.93	6746.0
2015-08-07 18:30:00	SPY	ETF	207.93	207.94	207.91	207.92	11527.0
2015-08-07 19:00:00	SPY	ETF	207.91	207.94	207.91	207.94	3595.0
2015-08-07 19:30:00	SPY	ETF	207.95	207.95	207.9	207.92	12897.0
2015-08-07 06:00:00	QQQ	ETF	110.31	110.31	110.31	110.31	5000.0
2015-08-07 06:30:00	QQQ	ETF	110.34	110.34	110.34	110.34	5000.0
2015-08-07 07:00:00	QQQ	ETF	110.32	110.32	110.25	110.26	6150.0
2015-08-07 07:30:00	QQQ	ETF	110.33	110.35	110.26	110.26	91800.0
2015-08-07 08:00:00	QQQ	ETF	110.27	110.34	110.23	110.28	44982.0
2015-08-07 08:30:00	QQQ	ETF	110.22	110.51	109.93	110.51	178369.0
2015-08-07 09:00:00	QQQ	ETF	110.47	110.47	110.14	110.18	165255.0
2015-08-07 09:30:00	QQQ	ETF	110.17	110.57	109.845	110.48	4588231.0
2015-08-07 10:00:00	QQQ	ETF	110.49	110.49	109.77	109.889	2077022.0
2015-08-07 10:30:00	QQQ	ETF	109.88	110.2	109.77	109.94	1496222.0
2015-08-07 11:00:00	QQQ	ETF	109.94	110.029	109.52	109.62	1738689.0
2015-08-07 11:30:00	QQQ	ETF	109.6	109.71	109.4	109.69	1665853.0
2015-08-07 12:00:00	QQQ	ETF	109.699	109.89	109.65	109.75	1345753.0
2015-08-07 12:30:00	QQQ	ETF	109.7499	109.79	109.585	109.64	795186.0
2015-08-07 13:00:00	QQQ	ETF	109.64	109.64	109.42	109.465	909567.0
2015-08-07 13:30:00	QQQ	ETF	109.46	109.74	109.455	109.56	900496.0
2015-08-07 14:00:00	QQQ	ETF	109.56	109.67	109.48	109.61	505494.0
2015-08-07 14:30:00	QQQ	ETF	109.613	109.88	109.613	109.87	944780.0

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

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