PREVIEW / etf_30min / 2018-02-15

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-15.parquet
  size:    490 KB
  rows:    16,976

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-02-15 04:00:00	SPY	ETF	271.18	271.68	271.18	271.63	29889.0
2018-02-15 04:30:00	SPY	ETF	271.67	271.79	271.66	271.74	23911.0
2018-02-15 05:00:00	SPY	ETF	271.7	271.75	271.62	271.69	14421.0
2018-02-15 05:30:00	SPY	ETF	271.55	271.59	271.4	271.4	6208.0
2018-02-15 06:00:00	SPY	ETF	271.41	271.46	270.82	271.05	51286.0
2018-02-15 06:30:00	SPY	ETF	271.0	271.01	270.69	270.92	47685.0
2018-02-15 07:00:00	SPY	ETF	270.92	271.19	270.89	270.95	104144.0
2018-02-15 07:30:00	SPY	ETF	270.95	270.95	270.45	270.65	155528.0
2018-02-15 08:00:00	SPY	ETF	270.63	271.43	270.44	270.55	431710.0
2018-02-15 08:30:00	SPY	ETF	270.52	271.26	270.11	271.07	585291.0
2018-02-15 09:00:00	SPY	ETF	271.08	271.61	271.08	271.56	880893.0
2018-02-15 09:30:00	SPY	ETF	271.57	271.65	270.64	271.45	10955237.0
2018-02-15 10:00:00	SPY	ETF	271.46	271.58	270.44	270.95	7226989.0
2018-02-15 10:30:00	SPY	ETF	270.94	271.56	269.15	269.22	7305994.0
2018-02-15 11:00:00	SPY	ETF	269.22	270.56	268.77	270.54	9026393.0
2018-02-15 11:30:00	SPY	ETF	270.54	270.95	270.11	270.6989	6238543.0
2018-02-15 12:00:00	SPY	ETF	270.69	271.03	270.37	270.87	4278837.0
2018-02-15 12:30:00	SPY	ETF	270.87	271.26	270.85	271.2398	3340451.0
2018-02-15 13:00:00	SPY	ETF	271.24	271.98	271.23	271.42	7226151.0
2018-02-15 13:30:00	SPY	ETF	271.44	271.83	271.11	271.67	3938126.0
2018-02-15 14:00:00	SPY	ETF	271.67	272.19	271.59	272.18	5568407.0
2018-02-15 14:30:00	SPY	ETF	272.18	272.41	272.01	272.15	4867311.0
2018-02-15 15:00:00	SPY	ETF	272.16	272.73	272.14	272.35	7297609.0
2018-02-15 15:30:00	SPY	ETF	272.345	273.01	271.83	273.0	17429732.0
2018-02-15 16:00:00	SPY	ETF	273.0	273.33	272.54	273.27	6836901.0
2018-02-15 16:30:00	SPY	ETF	273.24	273.54	273.03	273.35	2248495.0
2018-02-15 17:00:00	SPY	ETF	273.35	273.45	273.26	273.43	1727034.0
2018-02-15 17:30:00	SPY	ETF	273.43	273.46	273.26	273.3	121159.0
2018-02-15 18:00:00	SPY	ETF	273.34	273.56	273.03	273.43	769848.0
2018-02-15 18:30:00	SPY	ETF	273.45	273.6	273.38	273.57	39171.0
2018-02-15 19:00:00	SPY	ETF	273.52	273.56	273.47	273.51	19207.0
2018-02-15 19:30:00	SPY	ETF	273.53	273.56	273.44	273.56	43503.0
2018-02-15 04:00:00	QQQ	ETF	163.8	164.08	163.5	164.08	33856.0
2018-02-15 04:30:00	QQQ	ETF	164.16	164.17	164.01	164.01	12441.0
2018-02-15 05:00:00	QQQ	ETF	164.05	164.16	164.05	164.15	6517.0
2018-02-15 05:30:00	QQQ	ETF	164.12	164.17	164.04	164.07	10358.0
2018-02-15 06:00:00	QQQ	ETF	164.02	164.1	163.83	163.91	12815.0
2018-02-15 06:30:00	QQQ	ETF	163.88	163.91	163.76	163.82	11148.0
2018-02-15 07:00:00	QQQ	ETF	163.9	164.08	163.79	163.81	144420.0
2018-02-15 07:30:00	QQQ	ETF	163.8	163.84	163.55	163.73	100843.0
2018-02-15 08:00:00	QQQ	ETF	163.92	164.15	163.5	163.5	46059.0
2018-02-15 08:30:00	QQQ	ETF	163.5	163.96	163.39	163.79	254897.0
2018-02-15 09:00:00	QQQ	ETF	163.82	164.14	163.81	164.1	300378.0
2018-02-15 09:30:00	QQQ	ETF	164.12	164.53	163.26	164.48	4610239.0
2018-02-15 10:00:00	QQQ	ETF	164.48	164.51	163.82	164.37	3746703.0
2018-02-15 10:30:00	QQQ	ETF	164.36	164.45	162.7	162.74	4530358.0
2018-02-15 11:00:00	QQQ	ETF	162.74	164.04	162.44	164.02	3948673.0
2018-02-15 11:30:00	QQQ	ETF	164.03	164.27	163.71	164.1162	1983926.0
2018-02-15 12:00:00	QQQ	ETF	164.11	164.33	163.8814	164.18	1367693.0
2018-02-15 12:30:00	QQQ	ETF	164.18	164.645	164.18	164.6207	1704897.0

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

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