PREVIEW / etf_30min / 2018-03-05

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-05.parquet
  size:    472 KB
  rows:    16,223

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-03-05 04:00:00	SPY	ETF	268.48	268.63	268.14	268.22	49224.0
2018-03-05 04:30:00	SPY	ETF	268.24	268.94	268.22	268.82	18221.0
2018-03-05 05:00:00	SPY	ETF	268.86	269.04	268.67	268.85	33675.0
2018-03-05 05:30:00	SPY	ETF	268.93	269.31	268.93	269.22	8373.0
2018-03-05 06:00:00	SPY	ETF	269.15	269.15	268.73	268.82	2630.0
2018-03-05 06:30:00	SPY	ETF	268.8	268.8	268.36	268.38	114312.0
2018-03-05 07:00:00	SPY	ETF	268.38	268.7	268.38	268.38	127906.0
2018-03-05 07:30:00	SPY	ETF	268.4	268.61	268.02	268.1	273042.0
2018-03-05 08:00:00	SPY	ETF	268.13	268.76	267.0	268.18	531429.0
2018-03-05 08:30:00	SPY	ETF	268.18	268.43	267.82	268.0	418087.0
2018-03-05 09:00:00	SPY	ETF	267.98	267.98	267.41	267.73	1445546.0
2018-03-05 09:30:00	SPY	ETF	267.73	268.63	267.62	268.06	8682644.0
2018-03-05 10:00:00	SPY	ETF	268.07	268.43	267.61	268.42	5045957.0
2018-03-05 10:30:00	SPY	ETF	268.44	269.69	268.201	269.66	4456128.0
2018-03-05 11:00:00	SPY	ETF	269.66	271.0325	269.54	270.78	7716365.0
2018-03-05 11:30:00	SPY	ETF	270.78	271.54	270.7	271.28	4905248.0
2018-03-05 12:00:00	SPY	ETF	271.27	271.75	270.86	271.24	6895181.0
2018-03-05 12:30:00	SPY	ETF	271.26	271.81	270.95	271.79	3629572.0
2018-03-05 13:00:00	SPY	ETF	271.79	272.23	271.73	271.773	5491394.0
2018-03-05 13:30:00	SPY	ETF	271.78	271.94	271.31	271.79	3819265.0
2018-03-05 14:00:00	SPY	ETF	271.8085	271.98	270.97	271.5	4487829.0
2018-03-05 14:30:00	SPY	ETF	271.5	272.55	271.42	272.52	4489509.0
2018-03-05 15:00:00	SPY	ETF	272.52	272.86	272.145	272.22	6992567.0
2018-03-05 15:30:00	SPY	ETF	272.22	272.89	272.07	272.21	14463709.0
2018-03-05 16:00:00	SPY	ETF	272.2	272.7	270.6621	271.9	8308306.0
2018-03-05 16:30:00	SPY	ETF	271.92	272.8167	271.74	272.01	2137644.0
2018-03-05 17:00:00	SPY	ETF	272.02	272.05	271.95	272.0	57927.0
2018-03-05 17:30:00	SPY	ETF	271.99	272.02	271.98	272.0	33999.0
2018-03-05 18:00:00	SPY	ETF	272.05	272.2	271.95	272.0	65374.0
2018-03-05 18:30:00	SPY	ETF	272.19	272.19	271.96	271.96	419582.0
2018-03-05 19:00:00	SPY	ETF	271.96	272.06	271.88	272.02	29516.0
2018-03-05 19:30:00	SPY	ETF	272.08	272.23	272.08	272.2	21838.0
2018-03-05 04:00:00	QQQ	ETF	165.66	166.5	165.4	165.4	110919.0
2018-03-05 04:30:00	QQQ	ETF	165.52	165.95	165.52	165.91	73662.0
2018-03-05 05:00:00	QQQ	ETF	165.9	166.09	165.85	165.93	81142.0
2018-03-05 05:30:00	QQQ	ETF	166.02	166.54	166.01	166.45	24801.0
2018-03-05 06:00:00	QQQ	ETF	166.36	166.36	166.04	166.05	72603.0
2018-03-05 06:30:00	QQQ	ETF	165.93	166.07	165.9	165.91	9651.0
2018-03-05 07:00:00	QQQ	ETF	165.87	166.05	165.72	165.78	45884.0
2018-03-05 07:30:00	QQQ	ETF	165.77	165.77	165.51	165.53	30915.0
2018-03-05 08:00:00	QQQ	ETF	165.56	165.99	164.5	165.79	91222.0
2018-03-05 08:30:00	QQQ	ETF	165.77	165.92	165.41	165.51	219289.0
2018-03-05 09:00:00	QQQ	ETF	165.47	165.47	165.09	165.29	250832.0
2018-03-05 09:30:00	QQQ	ETF	165.26	165.74	164.79	165.175	4134248.0
2018-03-05 10:00:00	QQQ	ETF	165.18	165.38	164.59	165.2	2678593.0
2018-03-05 10:30:00	QQQ	ETF	165.21	166.23	165.08	166.19	2678131.0
2018-03-05 11:00:00	QQQ	ETF	166.21	166.87	166.13	166.74	3068558.0
2018-03-05 11:30:00	QQQ	ETF	166.74	167.46	166.72	167.38	2114494.0
2018-03-05 12:00:00	QQQ	ETF	167.37	167.73	167.09	167.35	2394622.0
2018-03-05 12:30:00	QQQ	ETF	167.36	167.735	167.2	167.71	1846732.0

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

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