PREVIEW / etf_30min / 2018-07-02

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-07-02.parquet
  size:    476 KB
  rows:    16,621

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
2018-07-02 04:00:00	SPY	ETF	269.8	269.84	269.5	269.72	20515.0
2018-07-02 04:30:00	SPY	ETF	269.8	270.13	269.63	270.11	32835.0
2018-07-02 05:00:00	SPY	ETF	270.06	270.08	269.87	269.87	10910.0
2018-07-02 05:30:00	SPY	ETF	269.88	269.99	269.7	269.9	24774.0
2018-07-02 06:00:00	SPY	ETF	269.9	269.93	269.42	269.56	46800.0
2018-07-02 06:30:00	SPY	ETF	269.54	270.03	269.53	269.97	87814.0
2018-07-02 07:00:00	SPY	ETF	269.97	270.06	269.81	269.94	96943.0
2018-07-02 07:30:00	SPY	ETF	269.93	270.1	269.8	270.08	70478.0
2018-07-02 08:00:00	SPY	ETF	270.0	271.28	269.21	269.89	203328.0
2018-07-02 08:30:00	SPY	ETF	269.87	269.87	269.58	269.66	245425.0
2018-07-02 09:00:00	SPY	ETF	271.28	271.28	269.36	269.49	479808.0
2018-07-02 09:30:00	SPY	ETF	269.51	270.11	269.24	270.0675	8004626.0
2018-07-02 10:00:00	SPY	ETF	270.04	270.45	269.61	270.27	5108079.0
2018-07-02 10:30:00	SPY	ETF	270.265	270.77	270.23	270.53	3738587.0
2018-07-02 11:00:00	SPY	ETF	270.53	271.07	270.235	270.37	3706152.0
2018-07-02 11:30:00	SPY	ETF	270.37	270.37	269.96	270.175	2800376.0
2018-07-02 12:00:00	SPY	ETF	270.17	270.22	269.69	270.01	2961342.0
2018-07-02 12:30:00	SPY	ETF	270.01	270.35	269.94	270.13	1677980.0
2018-07-02 13:00:00	SPY	ETF	270.125	270.22	269.58	269.6299	2216783.0
2018-07-02 13:30:00	SPY	ETF	269.62	270.68	269.59	270.55	2960872.0
2018-07-02 14:00:00	SPY	ETF	270.54	271.23	270.51	271.23	3583267.0
2018-07-02 14:30:00	SPY	ETF	271.22	271.38	270.73	270.78	2443144.0
2018-07-02 15:00:00	SPY	ETF	270.78	271.35	270.62	271.33	3798033.0
2018-07-02 15:30:00	SPY	ETF	271.33	272.04	271.05	271.94	9728608.0
2018-07-02 16:00:00	SPY	ETF	271.91	272.0	270.0441	271.95	7518020.0
2018-07-02 16:30:00	SPY	ETF	271.96	271.99	271.79	271.91	202762.0
2018-07-02 17:00:00	SPY	ETF	271.88	271.97	271.88	271.94	170201.0
2018-07-02 17:30:00	SPY	ETF	271.94	271.94	271.87	271.88	39843.0
2018-07-02 18:00:00	SPY	ETF	271.91	271.92	271.75	271.87	90132.0
2018-07-02 18:30:00	SPY	ETF	271.82	271.82	271.71	271.76	32888.0
2018-07-02 19:00:00	SPY	ETF	271.77	271.8	271.74	271.74	13750.0
2018-07-02 19:30:00	SPY	ETF	271.75	271.93	271.75	271.91	8335.0
2018-07-02 04:00:00	QQQ	ETF	170.29	170.39	170.1	170.25	11200.0
2018-07-02 04:30:00	QQQ	ETF	170.27	170.52	170.21	170.42	6075.0
2018-07-02 05:00:00	QQQ	ETF	170.45	170.51	170.41	170.44	2800.0
2018-07-02 05:30:00	QQQ	ETF	170.36	170.51	170.26	170.4	13000.0
2018-07-02 06:00:00	QQQ	ETF	170.37	170.45	170.13	170.2	9480.0
2018-07-02 06:30:00	QQQ	ETF	170.24	170.53	170.19	170.46	14700.0
2018-07-02 07:00:00	QQQ	ETF	170.48	170.57	170.38	170.46	43186.0
2018-07-02 07:30:00	QQQ	ETF	170.46	170.74	170.36	170.52	117525.0
2018-07-02 08:00:00	QQQ	ETF	170.5	170.52	170.21	170.27	53662.0
2018-07-02 08:30:00	QQQ	ETF	170.27	171.65	170.15	170.23	182512.0
2018-07-02 09:00:00	QQQ	ETF	171.65	171.65	169.82	170.05	252641.0
2018-07-02 09:30:00	QQQ	ETF	170.04	170.875	169.67	170.8388	5223485.0
2018-07-02 10:00:00	QQQ	ETF	170.81	171.24	170.5586	171.23	2688967.0
2018-07-02 10:30:00	QQQ	ETF	171.24	171.52	171.05	171.24	2114612.0
2018-07-02 11:00:00	QQQ	ETF	171.24	171.65	171.04	171.24	1703156.0
2018-07-02 11:30:00	QQQ	ETF	171.23	171.24	170.79	170.98	1149248.0
2018-07-02 12:00:00	QQQ	ETF	170.97	171.075	170.76	171.04	960826.0
2018-07-02 12:30:00	QQQ	ETF	171.03	171.17	170.9	171.04	722129.0

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

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