PREVIEW / etf_30min / 2016-07-15

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-15.parquet
  size:    399 KB
  rows:    13,517

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-15 04:00:00	SPY	ETF	215.94	216.07	215.88	215.88	2600.0
2016-07-15 04:30:00	SPY	ETF	215.9	215.9	215.69	215.8	15223.0
2016-07-15 05:00:00	SPY	ETF	215.86	215.86	215.56	215.74	10129.0
2016-07-15 05:30:00	SPY	ETF	215.84	215.99	215.71	215.89	39971.0
2016-07-15 06:00:00	SPY	ETF	215.89	216.09	215.87	216.03	21468.0
2016-07-15 06:30:00	SPY	ETF	216.03	216.04	215.75	215.77	25143.0
2016-07-15 07:00:00	SPY	ETF	215.79	216.08	215.79	216.08	45653.0
2016-07-15 07:30:00	SPY	ETF	216.1	216.32	216.08	216.3	159003.0
2016-07-15 08:00:00	SPY	ETF	216.04	216.37	215.9	216.19	359434.0
2016-07-15 08:30:00	SPY	ETF	216.24	216.57	216.2	216.46	406890.0
2016-07-15 09:00:00	SPY	ETF	216.5	216.85	216.31	216.78	1936758.0
2016-07-15 09:30:00	SPY	ETF	216.78	216.82	216.21	216.29	10184476.0
2016-07-15 10:00:00	SPY	ETF	216.29	217.0125	216.07	216.31	10794983.0
2016-07-15 10:30:00	SPY	ETF	216.305	216.43	216.23	216.2838	6167136.0
2016-07-15 11:00:00	SPY	ETF	216.285	216.33	215.75	215.81	6809013.0
2016-07-15 11:30:00	SPY	ETF	215.81	215.92	215.53	215.63	3960442.0
2016-07-15 12:00:00	SPY	ETF	215.63	215.76	215.5249	215.64	3351842.0
2016-07-15 12:30:00	SPY	ETF	215.645	215.67	215.308	215.42	4599112.0
2016-07-15 13:00:00	SPY	ETF	215.42	215.75	215.42	215.68	5076303.0
2016-07-15 13:30:00	SPY	ETF	215.68	215.82	215.59	215.705	3525914.0
2016-07-15 14:00:00	SPY	ETF	215.705	215.81	215.54	215.65	2479319.0
2016-07-15 14:30:00	SPY	ETF	215.64	215.87	215.61	215.8	6265542.0
2016-07-15 15:00:00	SPY	ETF	215.79	216.0	215.71	215.96	5606533.0
2016-07-15 15:30:00	SPY	ETF	215.955	216.09	215.79	215.81	17490575.0
2016-07-15 16:00:00	SPY	ETF	215.82	215.93	215.4	215.46	7575080.0
2016-07-15 16:30:00	SPY	ETF	215.46	215.88	214.73	214.98	2756334.0
2016-07-15 17:00:00	SPY	ETF	214.99	215.84	214.95	215.04	548174.0
2016-07-15 17:30:00	SPY	ETF	215.04	215.83	215.01	215.06	1870423.0
2016-07-15 18:00:00	SPY	ETF	215.06	215.83	214.86	214.95	706576.0
2016-07-15 18:30:00	SPY	ETF	214.98	215.0	214.69	214.69	189861.0
2016-07-15 19:00:00	SPY	ETF	214.75	214.75	214.12	214.3	252843.0
2016-07-15 19:30:00	SPY	ETF	214.3	214.72	214.0	214.55	201825.0
2016-07-15 04:00:00	QQQ	ETF	111.92	111.99	111.91	111.91	1400.0
2016-07-15 04:30:00	QQQ	ETF	111.89	111.89	111.84	111.84	900.0
2016-07-15 05:30:00	QQQ	ETF	111.88	111.89	111.87	111.87	1300.0
2016-07-15 06:00:00	QQQ	ETF	111.94	111.98	111.94	111.98	400.0
2016-07-15 06:30:00	QQQ	ETF	111.98	111.98	111.98	111.98	800.0
2016-07-15 07:00:00	QQQ	ETF	111.87	111.97	111.86	111.97	4100.0
2016-07-15 07:30:00	QQQ	ETF	111.98	112.02	111.98	112.02	8500.0
2016-07-15 08:00:00	QQQ	ETF	111.97	112.06	111.95	112.05	25591.0
2016-07-15 08:30:00	QQQ	ETF	112.06	112.13	112.02	112.06	26209.0
2016-07-15 09:00:00	QQQ	ETF	112.0	112.3	111.96	112.24	413252.0
2016-07-15 09:30:00	QQQ	ETF	112.22	112.3	111.985	112.06	2396728.0
2016-07-15 10:00:00	QQQ	ETF	112.05	112.1	111.83	111.94	1477054.0
2016-07-15 10:30:00	QQQ	ETF	111.94	112.06	111.89	111.985	891308.0
2016-07-15 11:00:00	QQQ	ETF	112.0	112.03	111.71	111.79	1305861.0
2016-07-15 11:30:00	QQQ	ETF	111.79	111.85	111.635	111.7	1030988.0
2016-07-15 12:00:00	QQQ	ETF	111.71	111.75	111.61	111.72	571030.0
2016-07-15 12:30:00	QQQ	ETF	111.72	111.73	111.55	111.61	666543.0
2016-07-15 13:00:00	QQQ	ETF	111.61	111.8	111.61	111.7635	447616.0

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

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