PREVIEW / etf_30min / 2017-04-28

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-28.parquet
  size:    421 KB
  rows:    14,436

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
2017-04-28 04:00:00	SPY	ETF	238.65	238.83	238.65	238.83	9519.0
2017-04-28 04:30:00	SPY	ETF	238.75	238.75	238.68	238.71	708.0
2017-04-28 05:00:00	SPY	ETF	238.73	238.81	238.73	238.81	10912.0
2017-04-28 05:30:00	SPY	ETF	238.77	238.93	238.74	238.93	3010.0
2017-04-28 06:00:00	SPY	ETF	238.92	238.92	238.86	238.91	1303.0
2017-04-28 06:30:00	SPY	ETF	238.82	238.93	238.82	238.83	3810.0
2017-04-28 07:00:00	SPY	ETF	238.9	238.95	238.83	238.91	101489.0
2017-04-28 07:30:00	SPY	ETF	238.95	238.95	238.75	238.82	71389.0
2017-04-28 08:00:00	SPY	ETF	238.9	238.95	238.76	238.9	174295.0
2017-04-28 08:30:00	SPY	ETF	238.86	238.91	238.73	238.8	88470.0
2017-04-28 09:00:00	SPY	ETF	238.8	238.96	238.77	238.9	173415.0
2017-04-28 09:30:00	SPY	ETF	238.9	238.93	238.44	238.525	5094907.0
2017-04-28 10:00:00	SPY	ETF	238.53	238.6	238.16	238.33	4064988.0
2017-04-28 10:30:00	SPY	ETF	238.34	238.46	238.1988	238.375	3432779.0
2017-04-28 11:00:00	SPY	ETF	238.38	238.44	238.14	238.265	2995677.0
2017-04-28 11:30:00	SPY	ETF	238.26	238.27	238.03	238.12	2491323.0
2017-04-28 12:00:00	SPY	ETF	238.12	238.345	238.12	238.28	1794290.0
2017-04-28 12:30:00	SPY	ETF	238.275	238.31	238.17	238.225	1728973.0
2017-04-28 13:00:00	SPY	ETF	238.22	238.28	238.03	238.18	1986375.0
2017-04-28 13:30:00	SPY	ETF	238.18	238.24	238.06	238.11	1386794.0
2017-04-28 14:00:00	SPY	ETF	238.1	238.2	237.93	238.07	3267052.0
2017-04-28 14:30:00	SPY	ETF	238.07	238.16	238.04	238.05	2125633.0
2017-04-28 15:00:00	SPY	ETF	238.04	238.25	237.99	238.11	4556204.0
2017-04-28 15:30:00	SPY	ETF	238.11	238.24	238.01	238.1	11997071.0
2017-04-28 16:00:00	SPY	ETF	238.11	238.29	238.05	238.16	10411360.0
2017-04-28 16:30:00	SPY	ETF	238.16	238.16	238.04	238.14	528954.0
2017-04-28 17:00:00	SPY	ETF	238.14	238.14	237.83	237.96	1629866.0
2017-04-28 17:30:00	SPY	ETF	237.95	238.08	237.86	237.89	475237.0
2017-04-28 18:00:00	SPY	ETF	237.89	237.95	237.83	237.95	30570.0
2017-04-28 18:30:00	SPY	ETF	237.91	237.95	237.86	237.88	17431.0
2017-04-28 19:00:00	SPY	ETF	237.9	237.93	237.85	237.93	14953.0
2017-04-28 19:30:00	SPY	ETF	237.96	237.96	237.93	237.93	6014.0
2017-04-28 04:00:00	QQQ	ETF	136.2	136.2	136.18	136.18	2070.0
2017-04-28 05:00:00	QQQ	ETF	136.23	136.23	136.23	136.23	500.0
2017-04-28 06:30:00	QQQ	ETF	136.28	136.28	136.27	136.27	988.0
2017-04-28 07:00:00	QQQ	ETF	136.31	136.4	136.29	136.37	34717.0
2017-04-28 07:30:00	QQQ	ETF	136.36	136.37	136.24	136.24	70450.0
2017-04-28 08:00:00	QQQ	ETF	136.36	136.36	136.18	136.21	68331.0
2017-04-28 08:30:00	QQQ	ETF	136.2	136.22	136.11	136.16	77848.0
2017-04-28 09:00:00	QQQ	ETF	136.14	136.3	136.11	136.29	198494.0
2017-04-28 09:30:00	QQQ	ETF	136.28	136.34	135.91	135.91	3491796.0
2017-04-28 10:00:00	QQQ	ETF	135.92	136.03	135.86	135.97	1405644.0
2017-04-28 10:30:00	QQQ	ETF	135.9796	136.07	135.86	136.07	1008812.0
2017-04-28 11:00:00	QQQ	ETF	136.07	136.0736	135.91	135.955	749946.0
2017-04-28 11:30:00	QQQ	ETF	135.95	135.965	135.8	135.86	710148.0
2017-04-28 12:00:00	QQQ	ETF	135.86	136.03	135.86	136.0	415996.0
2017-04-28 12:30:00	QQQ	ETF	136.0007	136.11	135.97	136.02	444685.0
2017-04-28 13:00:00	QQQ	ETF	136.0293	136.08	135.93	135.98	486480.0
2017-04-28 13:30:00	QQQ	ETF	135.97	136.0	135.92	135.93	407828.0
2017-04-28 14:00:00	QQQ	ETF	135.92	135.958	135.77	135.86	878175.0

> showing 50 of 14,436 rows — these rows as CSV

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