PREVIEW / etf_30min / 2018-03-27

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-27.parquet
  size:    473 KB
  rows:    16,272

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-27 04:00:00	SPY	ETF	266.36	266.39	266.1	266.35	25991.0
2018-03-27 04:30:00	SPY	ETF	266.32	266.7	266.32	266.57	14608.0
2018-03-27 05:00:00	SPY	ETF	266.66	266.86	266.61	266.85	14791.0
2018-03-27 05:30:00	SPY	ETF	266.88	267.1	266.85	267.1	18195.0
2018-03-27 06:00:00	SPY	ETF	267.05	267.08	266.56	266.61	18430.0
2018-03-27 06:30:00	SPY	ETF	266.63	266.64	266.39	266.39	32446.0
2018-03-27 07:00:00	SPY	ETF	266.39	266.77	266.39	266.66	131933.0
2018-03-27 07:30:00	SPY	ETF	266.63	266.68	266.34	266.47	149656.0
2018-03-27 08:00:00	SPY	ETF	266.49	266.94	266.01	266.22	347758.0
2018-03-27 08:30:00	SPY	ETF	266.21	266.27	265.86	265.88	815044.0
2018-03-27 09:00:00	SPY	ETF	265.88	266.17	265.73	266.15	501202.0
2018-03-27 09:30:00	SPY	ETF	266.17	266.21	264.79	265.63	7893648.0
2018-03-27 10:00:00	SPY	ETF	265.63	266.02	264.56	265.05	7819761.0
2018-03-27 10:30:00	SPY	ETF	265.05	265.68	264.47	265.13	4554862.0
2018-03-27 11:00:00	SPY	ETF	265.14	265.39	264.64	265.34	4600787.0
2018-03-27 11:30:00	SPY	ETF	265.34	266.71	265.34	266.55	7361221.0
2018-03-27 12:00:00	SPY	ETF	266.56	266.77	265.78	265.9	5062788.0
2018-03-27 12:30:00	SPY	ETF	265.8934	266.12	265.3	265.91	4725598.0
2018-03-27 13:00:00	SPY	ETF	265.91	266.5	265.61	265.6399	3751461.0
2018-03-27 13:30:00	SPY	ETF	265.6499	265.82	264.18	264.83	6567083.0
2018-03-27 14:00:00	SPY	ETF	264.83	265.11	263.85	263.86	7127409.0
2018-03-27 14:30:00	SPY	ETF	263.86	264.709	262.93	263.04	6943332.0
2018-03-27 15:00:00	SPY	ETF	263.04	263.12	260.64	260.73	16128054.0
2018-03-27 15:30:00	SPY	ETF	260.73	260.89	258.84	260.53	30540326.0
2018-03-27 16:00:00	SPY	ETF	260.53	265.1259	260.4258	260.83	9824507.0
2018-03-27 16:30:00	SPY	ETF	260.81	260.81	260.3	260.4	614743.0
2018-03-27 17:00:00	SPY	ETF	260.54	260.6	260.13	260.24	182679.0
2018-03-27 17:30:00	SPY	ETF	260.29	260.6	260.2	260.42	218079.0
2018-03-27 18:00:00	SPY	ETF	260.42	260.47	260.09	260.28	100611.0
2018-03-27 18:30:00	SPY	ETF	260.35	260.69	260.22	260.64	170284.0
2018-03-27 19:00:00	SPY	ETF	260.69	260.77	260.24	260.25	292513.0
2018-03-27 19:30:00	SPY	ETF	260.25	260.9	260.25	260.83	55340.0
2018-03-27 04:00:00	QQQ	ETF	165.71	165.8	165.53	165.6	40958.0
2018-03-27 04:30:00	QQQ	ETF	165.69	165.93	165.69	165.9	14222.0
2018-03-27 05:00:00	QQQ	ETF	165.85	166.01	165.81	165.99	7970.0
2018-03-27 05:30:00	QQQ	ETF	166.02	166.3	166.02	166.26	20566.0
2018-03-27 06:00:00	QQQ	ETF	166.27	166.27	165.86	165.9	21120.0
2018-03-27 06:30:00	QQQ	ETF	165.92	165.96	165.74	165.81	17054.0
2018-03-27 07:00:00	QQQ	ETF	165.78	166.13	165.78	166.0	91124.0
2018-03-27 07:30:00	QQQ	ETF	166.06	166.1	158.978	165.87	282733.0
2018-03-27 08:00:00	QQQ	ETF	165.89	166.07	165.74	165.74	372458.0
2018-03-27 08:30:00	QQQ	ETF	165.75	165.78	165.45	165.5	150476.0
2018-03-27 09:00:00	QQQ	ETF	165.49	165.61	158.978	165.6	361724.0
2018-03-27 09:30:00	QQQ	ETF	165.6	165.62	164.5	165.15	5208112.0
2018-03-27 10:00:00	QQQ	ETF	165.16	165.42	164.18	164.59	4044281.0
2018-03-27 10:30:00	QQQ	ETF	164.58	165.03	164.15	164.3	2053343.0
2018-03-27 11:00:00	QQQ	ETF	164.29	164.36	163.88	164.145	1748776.0
2018-03-27 11:30:00	QQQ	ETF	164.14	165.21	164.14	164.88	2125905.0
2018-03-27 12:00:00	QQQ	ETF	164.89	165.02	163.65	163.71	1731571.0
2018-03-27 12:30:00	QQQ	ETF	163.7	164.0	163.21	163.8	2660484.0

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

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