PREVIEW / etf_30min / 2016-07-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-22.parquet
  size:    383 KB
  rows:    12,959

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-07-22 04:00:00	SPY	ETF	216.39	216.5	216.26	216.26	3140.0
2016-07-22 04:30:00	SPY	ETF	216.33	216.65	216.33	216.63	2951.0
2016-07-22 05:00:00	SPY	ETF	216.68	216.78	216.67	216.78	5547.0
2016-07-22 05:30:00	SPY	ETF	216.75	216.75	216.45	216.45	26448.0
2016-07-22 06:00:00	SPY	ETF	216.42	216.6	216.42	216.58	5971.0
2016-07-22 06:30:00	SPY	ETF	216.64	216.65	216.58	216.64	2894.0
2016-07-22 07:00:00	SPY	ETF	216.6	216.66	216.55	216.55	35104.0
2016-07-22 07:30:00	SPY	ETF	216.57	216.59	216.37	216.44	90310.0
2016-07-22 08:00:00	SPY	ETF	216.46	216.62	216.31	216.51	166986.0
2016-07-22 08:30:00	SPY	ETF	216.53	216.56	216.46	216.5	123187.0
2016-07-22 09:00:00	SPY	ETF	216.46	216.49	216.39	216.41	184970.0
2016-07-22 09:30:00	SPY	ETF	216.41	216.48	216.1	216.24	5448388.0
2016-07-22 10:00:00	SPY	ETF	216.23	216.48	216.2	216.43	3150780.0
2016-07-22 10:30:00	SPY	ETF	216.425	216.77	216.35	216.745	4134709.0
2016-07-22 11:00:00	SPY	ETF	216.745	216.76	216.54	216.6	2391497.0
2016-07-22 11:30:00	SPY	ETF	216.6	217.0	216.57	216.97	3596640.0
2016-07-22 12:00:00	SPY	ETF	216.965	217.09	216.89	217.05	3809098.0
2016-07-22 12:30:00	SPY	ETF	217.05	217.1	216.95	216.99	2367500.0
2016-07-22 13:00:00	SPY	ETF	217.0	217.09	216.95	217.07	2475216.0
2016-07-22 13:30:00	SPY	ETF	217.08	217.13	216.945	217.045	1990295.0
2016-07-22 14:00:00	SPY	ETF	217.05	217.15	216.98	217.09	2201464.0
2016-07-22 14:30:00	SPY	ETF	217.095	217.1896	217.03	217.15	2299863.0
2016-07-22 15:00:00	SPY	ETF	217.15	217.3	217.05	217.21	6342561.0
2016-07-22 15:30:00	SPY	ETF	217.21	217.3	217.1	217.23	10761303.0
2016-07-22 16:00:00	SPY	ETF	217.24	217.25	217.01	217.02	8040616.0
2016-07-22 16:30:00	SPY	ETF	217.02	217.13	216.98	217.11	889911.0
2016-07-22 17:00:00	SPY	ETF	217.11	217.25	217.07	217.2	490838.0
2016-07-22 17:30:00	SPY	ETF	217.2	217.2	217.13	217.15	50193.0
2016-07-22 18:00:00	SPY	ETF	217.16	217.17	217.12	217.17	21020.0
2016-07-22 18:30:00	SPY	ETF	217.14	217.18	217.14	217.16	21356.0
2016-07-22 19:00:00	SPY	ETF	217.14	217.17	217.14	217.16	5180.0
2016-07-22 19:30:00	SPY	ETF	217.17	217.17	217.1	217.13	30552.0
2016-07-22 04:00:00	QQQ	ETF	113.33	113.33	113.33	113.33	200.0
2016-07-22 04:30:00	QQQ	ETF	113.23	113.46	113.23	113.45	1500.0
2016-07-22 05:00:00	QQQ	ETF	113.45	113.45	113.45	113.45	300.0
2016-07-22 06:00:00	QQQ	ETF	113.37	113.37	113.37	113.37	100.0
2016-07-22 07:00:00	QQQ	ETF	113.32	113.35	113.31	113.34	6100.0
2016-07-22 07:30:00	QQQ	ETF	113.3	113.32	113.24	113.24	11975.0
2016-07-22 08:00:00	QQQ	ETF	113.34	113.34	113.25	113.3	77970.0
2016-07-22 08:30:00	QQQ	ETF	113.3	113.34	113.29	113.32	99416.0
2016-07-22 09:00:00	QQQ	ETF	113.3	113.33	113.25	113.28	110066.0
2016-07-22 09:30:00	QQQ	ETF	113.28	113.32	112.911	113.1901	2107959.0
2016-07-22 10:00:00	QQQ	ETF	113.1801	113.48	113.16	113.35	1264998.0
2016-07-22 10:30:00	QQQ	ETF	113.35	113.55	113.33	113.52	780003.0
2016-07-22 11:00:00	QQQ	ETF	113.52	113.54	113.36	113.4527	561800.0
2016-07-22 11:30:00	QQQ	ETF	113.459	113.72	113.44	113.7	671859.0
2016-07-22 12:00:00	QQQ	ETF	113.7	113.78	113.64	113.77	850866.0
2016-07-22 12:30:00	QQQ	ETF	113.77	113.77	113.65	113.67	688044.0
2016-07-22 13:00:00	QQQ	ETF	113.67	113.6757	113.61	113.66	437039.0
2016-07-22 13:30:00	QQQ	ETF	113.654	113.68	113.56	113.65	511745.0

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

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