PREVIEW / etf_30min / 2015-12-31

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-31.parquet
  size:    397 KB
  rows:    13,323

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-12-31 04:00:00	SPY	ETF	205.94	206.01	205.92	206.0	700.0
2015-12-31 04:30:00	SPY	ETF	205.98	205.98	205.9	205.92	26200.0
2015-12-31 05:00:00	SPY	ETF	205.92	206.0	205.92	205.95	12700.0
2015-12-31 05:30:00	SPY	ETF	205.95	206.0	205.92	205.92	1600.0
2015-12-31 06:00:00	SPY	ETF	205.94	206.01	205.94	206.01	1600.0
2015-12-31 06:30:00	SPY	ETF	206.01	206.01	205.9	205.9	800.0
2015-12-31 07:00:00	SPY	ETF	205.9	205.93	205.59	205.64	36383.0
2015-12-31 07:30:00	SPY	ETF	205.59	205.7	205.43	205.52	55144.0
2015-12-31 08:00:00	SPY	ETF	205.48	205.51	205.24	205.3	200072.0
2015-12-31 08:30:00	SPY	ETF	205.3	205.37	204.95	205.22	384121.0
2015-12-31 09:00:00	SPY	ETF	205.21	205.35	205.11	205.12	427147.0
2015-12-31 09:30:00	SPY	ETF	205.13	205.18	204.62	204.935	9574298.0
2015-12-31 10:00:00	SPY	ETF	204.91	205.0	204.5	204.54	5429914.0
2015-12-31 10:30:00	SPY	ETF	204.53	204.58	204.17	204.559	7197321.0
2015-12-31 11:00:00	SPY	ETF	204.55	204.84	204.49	204.7	5157385.0
2015-12-31 11:30:00	SPY	ETF	204.7	205.37	204.56	205.36	6123258.0
2015-12-31 12:00:00	SPY	ETF	205.3601	205.74	205.26	205.705	5607736.0
2015-12-31 12:30:00	SPY	ETF	205.7	205.89	205.485	205.485	3896874.0
2015-12-31 13:00:00	SPY	ETF	205.4801	205.57	205.02	205.19	3739165.0
2015-12-31 13:30:00	SPY	ETF	205.1859	205.52	205.12	205.49	2332591.0
2015-12-31 14:00:00	SPY	ETF	205.4899	205.54	204.7	204.82	5490370.0
2015-12-31 14:30:00	SPY	ETF	204.82	204.91	204.48	204.71	6007992.0
2015-12-31 15:00:00	SPY	ETF	204.71	204.77	204.36	204.505	8277937.0
2015-12-31 15:30:00	SPY	ETF	204.51	204.91	203.87	203.93	19600907.0
2015-12-31 16:00:00	SPY	ETF	203.92	204.4353	203.54	203.99	20689708.0
2015-12-31 16:30:00	SPY	ETF	203.99	204.07	203.94	204.0	2501765.0
2015-12-31 17:00:00	SPY	ETF	204.0	204.04	203.87	204.0	387831.0
2015-12-31 17:30:00	SPY	ETF	203.95	203.98	203.92	203.98	8500.0
2015-12-31 18:00:00	SPY	ETF	203.98	204.05	203.96	204.05	11016.0
2015-12-31 18:30:00	SPY	ETF	204.05	204.21	204.0	204.05	39452.0
2015-12-31 19:00:00	SPY	ETF	204.05	204.09	204.01	204.01	1600.0
2015-12-31 19:30:00	SPY	ETF	204.04	204.09	204.02	204.07	4057.0
2015-12-31 05:30:00	QQQ	ETF	113.4	113.4	113.39	113.4	400.0
2015-12-31 06:00:00	QQQ	ETF	113.45	113.45	113.45	113.45	100.0
2015-12-31 06:30:00	QQQ	ETF	113.42	113.44	113.33	113.33	1800.0
2015-12-31 07:00:00	QQQ	ETF	113.35	113.38	113.12	113.13	10051.0
2015-12-31 07:30:00	QQQ	ETF	113.1	113.19	113.1	113.1	15817.0
2015-12-31 08:00:00	QQQ	ETF	113.14	113.15	112.99	113.03	21304.0
2015-12-31 08:30:00	QQQ	ETF	113.04	113.04	112.83	112.9	59126.0
2015-12-31 09:00:00	QQQ	ETF	112.91	112.97	112.86	112.87	76889.0
2015-12-31 09:30:00	QQQ	ETF	112.87	112.94	112.46	112.63	3301709.0
2015-12-31 10:00:00	QQQ	ETF	112.62	112.6975	112.35	112.36	1890497.0
2015-12-31 10:30:00	QQQ	ETF	112.36	112.48	112.18	112.44	1821618.0
2015-12-31 11:00:00	QQQ	ETF	112.43	112.625	112.4	112.515	2062569.0
2015-12-31 11:30:00	QQQ	ETF	112.5	112.81	112.42	112.8	1825553.0
2015-12-31 12:00:00	QQQ	ETF	112.7941	112.9678	112.74	112.9229	1885401.0
2015-12-31 12:30:00	QQQ	ETF	112.9361	113.08	112.83	112.83	970838.0
2015-12-31 13:00:00	QQQ	ETF	112.82	112.87	112.52	112.54	949794.0
2015-12-31 13:30:00	QQQ	ETF	112.54	112.74	112.49	112.71	623181.0
2015-12-31 14:00:00	QQQ	ETF	112.71	112.7433	112.2672	112.31	993229.0

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

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