PREVIEW / etf_30min / 2015-10-28

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-28.parquet
  size:    392 KB
  rows:    13,093

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-10-28 04:00:00	SPY	ETF	206.84	207.05	206.77	207.03	15003.0
2015-10-28 04:30:00	SPY	ETF	207.02	207.08	207.02	207.08	854.0
2015-10-28 05:00:00	SPY	ETF	207.08	207.13	207.02	207.13	5811.0
2015-10-28 05:30:00	SPY	ETF	207.1	207.25	207.02	207.25	2622.0
2015-10-28 06:00:00	SPY	ETF	207.16	207.22	207.1	207.17	2857.0
2015-10-28 06:30:00	SPY	ETF	207.12	207.12	207.05	207.08	21603.0
2015-10-28 07:00:00	SPY	ETF	207.08	207.14	207.04	207.1	37608.0
2015-10-28 07:30:00	SPY	ETF	207.12	207.16	207.04	207.04	87885.0
2015-10-28 08:00:00	SPY	ETF	207.03	207.17	206.9	206.98	157458.0
2015-10-28 08:30:00	SPY	ETF	207.0	207.02	206.88	206.89	129133.0
2015-10-28 09:00:00	SPY	ETF	206.9	207.1	206.9	206.98	353002.0
2015-10-28 09:30:00	SPY	ETF	207.0	207.36	206.66	207.35	9285236.0
2015-10-28 10:00:00	SPY	ETF	207.35	207.54	207.28	207.31	6133109.0
2015-10-28 10:30:00	SPY	ETF	207.32	208.02	207.32	208.01	8014521.0
2015-10-28 11:00:00	SPY	ETF	208.01	208.11	207.76	207.9	4908152.0
2015-10-28 11:30:00	SPY	ETF	207.9	208.19	207.825	208.15	5862926.0
2015-10-28 12:00:00	SPY	ETF	208.15	208.23	208.01	208.07	4090860.0
2015-10-28 12:30:00	SPY	ETF	208.08	208.08	207.78	207.87	2966760.0
2015-10-28 13:00:00	SPY	ETF	207.88	207.97	207.8202	207.85	2498479.0
2015-10-28 13:30:00	SPY	ETF	207.86	208.47	207.82	208.362	6089752.0
2015-10-28 14:00:00	SPY	ETF	208.37	208.4	206.21	207.06	30910897.0
2015-10-28 14:30:00	SPY	ETF	207.05	207.57	206.46	207.45	12917595.0
2015-10-28 15:00:00	SPY	ETF	207.44	208.19	207.3067	208.14	12222832.0
2015-10-28 15:30:00	SPY	ETF	208.15	208.97	208.11	208.96	21786981.0
2015-10-28 16:00:00	SPY	ETF	208.97	209.12	208.84	208.92	5830962.0
2015-10-28 16:30:00	SPY	ETF	208.91	209.0	208.75	208.81	422760.0
2015-10-28 17:00:00	SPY	ETF	208.79	208.9	208.79	208.9	52904.0
2015-10-28 17:30:00	SPY	ETF	208.85	208.98	208.76	208.78	336248.0
2015-10-28 18:00:00	SPY	ETF	208.75	208.95	208.68	208.72	117710.0
2015-10-28 18:30:00	SPY	ETF	208.72	208.76	208.68	208.68	20039.0
2015-10-28 19:00:00	SPY	ETF	208.7	208.71	208.63	208.65	25480.0
2015-10-28 19:30:00	SPY	ETF	208.66	208.72	208.62	208.71	112501.0
2015-10-28 04:00:00	QQQ	ETF	113.28	113.28	113.23	113.23	200.0
2015-10-28 04:30:00	QQQ	ETF	113.37	113.4	113.37	113.4	6950.0
2015-10-28 05:00:00	QQQ	ETF	113.39	113.42	113.39	113.42	200.0
2015-10-28 05:30:00	QQQ	ETF	113.5	113.5	113.5	113.5	6250.0
2015-10-28 06:00:00	QQQ	ETF	113.46	113.51	113.46	113.47	2700.0
2015-10-28 06:30:00	QQQ	ETF	113.45	113.48	113.44	113.44	4000.0
2015-10-28 07:00:00	QQQ	ETF	113.47	113.49	113.43	113.43	13971.0
2015-10-28 07:30:00	QQQ	ETF	113.44	113.44	113.41	113.42	5800.0
2015-10-28 08:00:00	QQQ	ETF	113.39	113.48	113.3	113.33	20406.0
2015-10-28 08:30:00	QQQ	ETF	113.33	113.34	113.22	113.22	80531.0
2015-10-28 09:00:00	QQQ	ETF	113.22	113.29	113.19	113.26	219171.0
2015-10-28 09:30:00	QQQ	ETF	113.25	113.34	112.85	113.18	3264740.0
2015-10-28 10:00:00	QQQ	ETF	113.18	113.23	112.73	112.894	1892680.0
2015-10-28 10:30:00	QQQ	ETF	112.895	113.255	112.895	113.2495	2171473.0
2015-10-28 11:00:00	QQQ	ETF	113.24	113.35	113.18	113.25	1875479.0
2015-10-28 11:30:00	QQQ	ETF	113.2476	113.46	113.21	113.45	1307285.0
2015-10-28 12:00:00	QQQ	ETF	113.4409	113.5532	113.39	113.51	998045.0
2015-10-28 12:30:00	QQQ	ETF	113.505	113.51	113.31	113.3555	749461.0

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

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