PREVIEW / etf_30min / 2019-02-11

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-11.parquet
  size:    478 KB
  rows:    16,930

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
2019-02-11 04:00:00	SPY	ETF	271.39	271.77	271.38	271.39	12274.0
2019-02-11 04:30:00	SPY	ETF	271.3	271.59	271.3	271.55	2430.0
2019-02-11 05:00:00	SPY	ETF	271.58	271.58	271.35	271.39	3680.0
2019-02-11 05:30:00	SPY	ETF	271.49	271.5	271.33	271.34	5262.0
2019-02-11 06:00:00	SPY	ETF	271.34	271.34	271.03	271.05	6781.0
2019-02-11 06:30:00	SPY	ETF	271.1	271.1	270.96	271.08	21077.0
2019-02-11 07:00:00	SPY	ETF	271.04	271.22	270.96	271.04	56867.0
2019-02-11 07:30:00	SPY	ETF	271.14	271.41	271.1	271.41	113766.0
2019-02-11 08:00:00	SPY	ETF	271.36	271.9	270.47	271.39	362393.0
2019-02-11 08:30:00	SPY	ETF	271.39	271.42	271.19	271.34	117481.0
2019-02-11 09:00:00	SPY	ETF	271.3	271.39	271.1	271.18	267658.0
2019-02-11 09:30:00	SPY	ETF	271.2	271.49	270.57	270.78	6992565.0
2019-02-11 10:00:00	SPY	ETF	270.78	271.13	270.43	270.58	4380477.0
2019-02-11 10:30:00	SPY	ETF	270.6	270.96	270.32	270.63	3245162.0
2019-02-11 11:00:00	SPY	ETF	270.64	270.85	270.14	270.58	3254169.0
2019-02-11 11:30:00	SPY	ETF	270.58	270.68	270.28	270.5193	4183176.0
2019-02-11 12:00:00	SPY	ETF	270.51	270.93	270.45	270.82	2631608.0
2019-02-11 12:30:00	SPY	ETF	270.82	270.95	270.61	270.7917	3287258.0
2019-02-11 13:00:00	SPY	ETF	270.8	270.93	270.47	270.4999	3582500.0
2019-02-11 13:30:00	SPY	ETF	270.49	270.57	270.215	270.48	4162863.0
2019-02-11 14:00:00	SPY	ETF	270.47	270.59	270.25	270.35	5637945.0
2019-02-11 14:30:00	SPY	ETF	270.35	270.57	270.03	270.295	2225226.0
2019-02-11 15:00:00	SPY	ETF	270.29	270.71	270.27	270.69	4180653.0
2019-02-11 15:30:00	SPY	ETF	270.68	270.87	270.29	270.6599	10625134.0
2019-02-11 16:00:00	SPY	ETF	270.66	270.75	270.39	270.63	7407659.0
2019-02-11 16:30:00	SPY	ETF	270.62	270.64	270.49	270.54	114513.0
2019-02-11 17:00:00	SPY	ETF	270.54	270.58	270.5	270.56	19909.0
2019-02-11 17:30:00	SPY	ETF	270.54	270.58	270.44	270.47	29709.0
2019-02-11 18:00:00	SPY	ETF	270.48	270.49	270.37	270.45	46120.0
2019-02-11 18:30:00	SPY	ETF	270.45	270.65	270.43	270.62	32588.0
2019-02-11 19:00:00	SPY	ETF	270.63	270.98	270.6	270.94	48699.0
2019-02-11 19:30:00	SPY	ETF	270.95	271.34	270.95	271.14	63075.0
2019-02-11 04:00:00	QQQ	ETF	169.17	169.64	169.17	169.25	36471.0
2019-02-11 04:30:00	QQQ	ETF	169.25	169.39	169.15	169.29	32183.0
2019-02-11 05:00:00	QQQ	ETF	169.26	169.3	169.23	169.27	5271.0
2019-02-11 05:30:00	QQQ	ETF	169.26	169.26	169.15	169.17	13625.0
2019-02-11 06:00:00	QQQ	ETF	169.24	169.24	168.93	168.97	17572.0
2019-02-11 06:30:00	QQQ	ETF	169.02	169.02	168.93	169.0	7650.0
2019-02-11 07:00:00	QQQ	ETF	168.96	169.14	168.89	169.07	27141.0
2019-02-11 07:30:00	QQQ	ETF	169.15	169.36	169.04	169.34	52475.0
2019-02-11 08:00:00	QQQ	ETF	169.13	169.54	168.15	169.28	54706.0
2019-02-11 08:30:00	QQQ	ETF	169.25	169.3	169.08	169.19	50393.0
2019-02-11 09:00:00	QQQ	ETF	169.14	169.28	169.09	169.15	152602.0
2019-02-11 09:30:00	QQQ	ETF	169.14	169.58	168.541	168.7615	3609711.0
2019-02-11 10:00:00	QQQ	ETF	168.75	169.19	168.58	168.74	2104039.0
2019-02-11 10:30:00	QQQ	ETF	168.77	169.05	168.54	168.71	1260884.0
2019-02-11 11:00:00	QQQ	ETF	168.71	168.85	168.25	168.61	1446111.0
2019-02-11 11:30:00	QQQ	ETF	168.6	168.6825	168.34	168.54	1123419.0
2019-02-11 12:00:00	QQQ	ETF	168.54	168.89	168.48	168.82	643284.0
2019-02-11 12:30:00	QQQ	ETF	168.83	168.87	168.6101	168.72	707949.0

> showing 50 of 16,930 rows — these rows as CSV

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