PREVIEW / etf_30min / 2015-05-05

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-05.parquet
  size:    388 KB
  rows:    13,043

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-05-05 04:00:00	SPY	ETF	211.24	211.62	211.24	211.62	13830.0
2015-05-05 04:30:00	SPY	ETF	211.61	211.64	211.2	211.22	6278.0
2015-05-05 05:00:00	SPY	ETF	211.24	211.25	211.1	211.17	20453.0
2015-05-05 05:30:00	SPY	ETF	211.17	211.42	211.15	211.32	29057.0
2015-05-05 06:00:00	SPY	ETF	211.32	211.35	211.14	211.17	17703.0
2015-05-05 06:30:00	SPY	ETF	211.17	211.17	211.04	211.13	23311.0
2015-05-05 07:00:00	SPY	ETF	211.12	211.17	211.01	211.12	92188.0
2015-05-05 07:30:00	SPY	ETF	211.1	211.34	211.09	211.29	70868.0
2015-05-05 08:00:00	SPY	ETF	211.31	211.41	211.1	211.24	295351.0
2015-05-05 08:30:00	SPY	ETF	211.24	211.25	210.65	210.77	759665.0
2015-05-05 09:00:00	SPY	ETF	210.79	211.1	210.68	211.03	613806.0
2015-05-05 09:30:00	SPY	ETF	211.03	211.46	210.57	210.63	10055679.0
2015-05-05 10:00:00	SPY	ETF	210.64	210.88	210.27	210.72	12217727.0
2015-05-05 10:30:00	SPY	ETF	210.71	210.77	210.34	210.51	5205807.0
2015-05-05 11:00:00	SPY	ETF	210.51	210.51	209.67	209.74	8438702.0
2015-05-05 11:30:00	SPY	ETF	209.74	209.95	209.5	209.9301	5992640.0
2015-05-05 12:00:00	SPY	ETF	209.9301	210.23	209.88	210.11	3881832.0
2015-05-05 12:30:00	SPY	ETF	210.11	210.13	209.75	209.77	3047609.0
2015-05-05 13:00:00	SPY	ETF	209.79	209.83	209.16	209.4894	6731648.0
2015-05-05 13:30:00	SPY	ETF	209.485	209.63	209.26	209.4	4423499.0
2015-05-05 14:00:00	SPY	ETF	209.405	209.62	209.14	209.24	6158975.0
2015-05-05 14:30:00	SPY	ETF	209.23	209.42	208.741	208.93	8388716.0
2015-05-05 15:00:00	SPY	ETF	208.93	209.2	208.73	209.11	11164840.0
2015-05-05 15:30:00	SPY	ETF	209.1	209.36	208.8	208.9	15287874.0
2015-05-05 16:00:00	SPY	ETF	208.89	209.05	208.8695	209.0	5341346.0
2015-05-05 16:30:00	SPY	ETF	209.04	209.15	209.04	209.11	1806410.0
2015-05-05 17:00:00	SPY	ETF	209.11	209.14	209.07	209.1	599671.0
2015-05-05 17:30:00	SPY	ETF	209.11	209.12	209.08	209.11	15011.0
2015-05-05 18:00:00	SPY	ETF	209.12	209.28	209.12	209.2	100067.0
2015-05-05 18:30:00	SPY	ETF	209.21	209.24	209.19	209.24	3664.0
2015-05-05 19:00:00	SPY	ETF	209.21	209.23	209.13	209.19	13765.0
2015-05-05 19:30:00	SPY	ETF	209.18	209.27	209.16	209.24	13022.0
2015-05-05 04:00:00	QQQ	ETF	109.08	109.08	109.0	109.0	2500.0
2015-05-05 04:30:00	QQQ	ETF	109.26	109.26	109.26	109.26	500.0
2015-05-05 06:00:00	QQQ	ETF	109.2	109.2	109.1	109.13	13600.0
2015-05-05 06:30:00	QQQ	ETF	109.02	109.02	109.01	109.02	900.0
2015-05-05 07:00:00	QQQ	ETF	109.01	109.06	108.97	108.98	18227.0
2015-05-05 07:30:00	QQQ	ETF	109.04	109.09	109.02	109.06	4734.0
2015-05-05 08:00:00	QQQ	ETF	109.09	109.12	109.02	109.02	111331.0
2015-05-05 08:30:00	QQQ	ETF	109.01	109.01	108.67	108.74	240177.0
2015-05-05 09:00:00	QQQ	ETF	108.72	108.85	108.66	108.79	233716.0
2015-05-05 09:30:00	QQQ	ETF	108.8	109.0	108.27	108.3	5242474.0
2015-05-05 10:00:00	QQQ	ETF	108.32	108.42	108.05	108.28	3919492.0
2015-05-05 10:30:00	QQQ	ETF	108.29	108.335	107.99	108.24	2590529.0
2015-05-05 11:00:00	QQQ	ETF	108.23	108.23	107.72	107.74	2766035.0
2015-05-05 11:30:00	QQQ	ETF	107.73	107.96	107.6	107.95	1814918.0
2015-05-05 12:00:00	QQQ	ETF	107.95	108.085	107.91	107.99	1089468.0
2015-05-05 12:30:00	QQQ	ETF	107.99	108.0299	107.8	107.84	1018117.0
2015-05-05 13:00:00	QQQ	ETF	107.86	107.87	107.55	107.6835	1919496.0
2015-05-05 13:30:00	QQQ	ETF	107.68	107.79	107.55	107.65	1083359.0

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

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