PREVIEW / etf_30min / 2016-01-05

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-05.parquet
  size:    393 KB
  rows:    13,170

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-01-05 04:00:00	SPY	ETF	201.14	201.14	200.33	200.4	14426.0
2016-01-05 04:30:00	SPY	ETF	200.36	200.61	200.36	200.61	8658.0
2016-01-05 05:00:00	SPY	ETF	200.34	200.34	199.82	199.95	279633.0
2016-01-05 05:30:00	SPY	ETF	200.02	200.24	200.0	200.22	4796.0
2016-01-05 06:00:00	SPY	ETF	200.2	200.33	200.04	200.05	39241.0
2016-01-05 06:30:00	SPY	ETF	200.18	200.28	200.01	200.14	52582.0
2016-01-05 07:00:00	SPY	ETF	200.36	200.37	200.07	200.28	200119.0
2016-01-05 07:30:00	SPY	ETF	200.2	200.54	200.03	200.54	201209.0
2016-01-05 08:00:00	SPY	ETF	199.93	202.225	199.93	200.98	722908.0
2016-01-05 08:30:00	SPY	ETF	201.0	201.47	200.91	201.31	709777.0
2016-01-05 09:00:00	SPY	ETF	201.3	201.47	201.01	201.39	775458.0
2016-01-05 09:30:00	SPY	ETF	201.4	201.8	200.89	200.92	11749334.0
2016-01-05 10:00:00	SPY	ETF	200.92	201.03	200.44	200.445	7902650.0
2016-01-05 10:30:00	SPY	ETF	200.46	201.49	200.35	201.3099	6361507.0
2016-01-05 11:00:00	SPY	ETF	201.3	201.435	200.6	200.75	6267974.0
2016-01-05 11:30:00	SPY	ETF	200.75	201.17	200.69	200.88	4762097.0
2016-01-05 12:00:00	SPY	ETF	200.8814	200.89	200.05	200.4	6933146.0
2016-01-05 12:30:00	SPY	ETF	200.4	200.61	200.18	200.6	3343260.0
2016-01-05 13:00:00	SPY	ETF	200.6	200.86	200.31	200.6	3953239.0
2016-01-05 13:30:00	SPY	ETF	200.59	201.49	200.535	201.28	7451092.0
2016-01-05 14:00:00	SPY	ETF	201.2892	201.9	201.05	201.7	9574991.0
2016-01-05 14:30:00	SPY	ETF	201.69	201.755	201.22	201.35	5515967.0
2016-01-05 15:00:00	SPY	ETF	201.34	201.37	200.78	201.2308	8706582.0
2016-01-05 15:30:00	SPY	ETF	201.235	201.68	201.09	201.43	13928602.0
2016-01-05 16:00:00	SPY	ETF	201.43	201.67	201.3	201.65	8992383.0
2016-01-05 16:30:00	SPY	ETF	201.67	201.75	201.5	201.52	378438.0
2016-01-05 17:00:00	SPY	ETF	201.56	201.56	201.49	201.52	86418.0
2016-01-05 17:30:00	SPY	ETF	201.52	201.56	201.5	201.55	76716.0
2016-01-05 18:00:00	SPY	ETF	201.58	201.7	201.58	201.69	189070.0
2016-01-05 18:30:00	SPY	ETF	201.69	201.69	201.56	201.59	84855.0
2016-01-05 19:00:00	SPY	ETF	201.57	201.76	201.54	201.6	20315.0
2016-01-05 19:30:00	SPY	ETF	201.58	201.65	201.45	201.65	95809.0
2016-01-05 04:00:00	QQQ	ETF	109.5	109.5	109.27	109.27	1400.0
2016-01-05 04:30:00	QQQ	ETF	109.3	109.42	109.3	109.33	1900.0
2016-01-05 05:00:00	QQQ	ETF	109.27	109.27	109.02	109.09	1118.0
2016-01-05 05:30:00	QQQ	ETF	109.15	109.15	109.13	109.13	500.0
2016-01-05 06:00:00	QQQ	ETF	109.09	109.21	109.08	109.11	2168.0
2016-01-05 06:30:00	QQQ	ETF	109.16	109.18	109.15	109.17	2500.0
2016-01-05 07:00:00	QQQ	ETF	109.29	109.32	109.24	109.32	68300.0
2016-01-05 07:30:00	QQQ	ETF	109.27	109.35	109.18	109.35	41850.0
2016-01-05 08:00:00	QQQ	ETF	109.39	109.82	109.28	109.71	104083.0
2016-01-05 08:30:00	QQQ	ETF	109.71	109.92	109.66	109.85	103032.0
2016-01-05 09:00:00	QQQ	ETF	109.82	110.07	109.72	110.04	340400.0
2016-01-05 09:30:00	QQQ	ETF	110.04	110.18	109.51	109.52	4937879.0
2016-01-05 10:00:00	QQQ	ETF	109.53	109.66	109.29	109.33	3022422.0
2016-01-05 10:30:00	QQQ	ETF	109.33	109.95	109.25	109.8	2601593.0
2016-01-05 11:00:00	QQQ	ETF	109.79	109.87	109.31	109.37	2104948.0
2016-01-05 11:30:00	QQQ	ETF	109.37	109.62	109.31	109.419	1730774.0
2016-01-05 12:00:00	QQQ	ETF	109.41	109.415	108.8	109.04	4389461.0
2016-01-05 12:30:00	QQQ	ETF	109.04	109.13	108.8	109.11	1389906.0

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

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