PREVIEW / etf_30min / 2018-08-24

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-24.parquet
  size:    465 KB
  rows:    15,831

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-08-24 04:00:00	SPY	ETF	286.3	286.45	286.3	286.44	2720.0
2018-08-24 04:30:00	SPY	ETF	286.31	286.4	286.26	286.4	5100.0
2018-08-24 05:00:00	SPY	ETF	286.36	286.38	286.28	286.29	1900.0
2018-08-24 05:30:00	SPY	ETF	286.25	286.37	286.22	286.3	2500.0
2018-08-24 06:00:00	SPY	ETF	286.26	286.48	286.26	286.48	8002.0
2018-08-24 06:30:00	SPY	ETF	286.48	286.48	286.36	286.45	7360.0
2018-08-24 07:00:00	SPY	ETF	286.46	286.5	286.36	286.4	19234.0
2018-08-24 07:30:00	SPY	ETF	286.39	286.47	286.36	286.4	11904.0
2018-08-24 08:00:00	SPY	ETF	286.46	286.46	286.18	286.29	49332.0
2018-08-24 08:30:00	SPY	ETF	286.25	286.45	286.25	286.31	68001.0
2018-08-24 09:00:00	SPY	ETF	286.33	286.48	286.31	286.44	119388.0
2018-08-24 09:30:00	SPY	ETF	286.44	286.66	286.38	286.45	5231263.0
2018-08-24 10:00:00	SPY	ETF	286.46	286.89	286.45	286.76	4439374.0
2018-08-24 10:30:00	SPY	ETF	286.77	287.415	286.757	287.195	5938719.0
2018-08-24 11:00:00	SPY	ETF	287.2	287.4	287.031	287.221	3681082.0
2018-08-24 11:30:00	SPY	ETF	287.22	287.6	287.19	287.59	3005636.0
2018-08-24 12:00:00	SPY	ETF	287.59	287.6699	287.49	287.63	2322723.0
2018-08-24 12:30:00	SPY	ETF	287.62	287.63	287.42	287.56	1878454.0
2018-08-24 13:00:00	SPY	ETF	287.56	287.67	287.33	287.4	2099670.0
2018-08-24 13:30:00	SPY	ETF	287.3914	287.42	287.03	287.38	2598729.0
2018-08-24 14:00:00	SPY	ETF	287.38	287.55	287.31	287.51	2151568.0
2018-08-24 14:30:00	SPY	ETF	287.5047	287.57	287.36	287.41	1559150.0
2018-08-24 15:00:00	SPY	ETF	287.4175	287.56	287.27	287.45	1830720.0
2018-08-24 15:30:00	SPY	ETF	287.45	287.61	287.34	287.5	8469083.0
2018-08-24 16:00:00	SPY	ETF	287.51	287.63	285.7309	287.63	9311220.0
2018-08-24 16:30:00	SPY	ETF	287.62	287.69	287.51	287.61	2043617.0
2018-08-24 17:00:00	SPY	ETF	287.59	287.63	287.52	287.55	25298.0
2018-08-24 17:30:00	SPY	ETF	287.55	287.55	287.53	287.53	15582.0
2018-08-24 18:00:00	SPY	ETF	287.55	287.56	287.53	287.53	1110.0
2018-08-24 18:30:00	SPY	ETF	287.53	287.65	287.53	287.65	4100.0
2018-08-24 19:00:00	SPY	ETF	287.55	287.63	287.55	287.63	2520.0
2018-08-24 19:30:00	SPY	ETF	287.65	287.65	287.56	287.63	13684.0
2018-08-24 04:00:00	QQQ	ETF	181.28	181.28	181.21	181.21	7970.0
2018-08-24 04:30:00	QQQ	ETF	181.22	181.22	181.22	181.22	500.0
2018-08-24 05:00:00	QQQ	ETF	181.22	181.22	181.17	181.2	850.0
2018-08-24 05:30:00	QQQ	ETF	181.15	181.18	181.15	181.16	1200.0
2018-08-24 06:00:00	QQQ	ETF	181.31	181.42	181.28	181.42	14300.0
2018-08-24 06:30:00	QQQ	ETF	181.4	181.4	181.31	181.31	6600.0
2018-08-24 07:00:00	QQQ	ETF	181.38	181.41	181.26	181.3	5956.0
2018-08-24 07:30:00	QQQ	ETF	181.33	181.4	181.29	181.3	40703.0
2018-08-24 08:00:00	QQQ	ETF	181.35	181.39	181.21	181.31	33421.0
2018-08-24 08:30:00	QQQ	ETF	181.31	181.41	181.28	181.33	66478.0
2018-08-24 09:00:00	QQQ	ETF	181.33	181.44	181.3	181.37	44476.0
2018-08-24 09:30:00	QQQ	ETF	181.39	181.77	181.36	181.54	2045452.0
2018-08-24 10:00:00	QQQ	ETF	181.55	182.02	181.545	181.96	1846850.0
2018-08-24 10:30:00	QQQ	ETF	181.96	182.5399	181.92	182.35	1873353.0
2018-08-24 11:00:00	QQQ	ETF	182.36	182.48	182.17	182.337	1139306.0
2018-08-24 11:30:00	QQQ	ETF	182.33	182.625	182.32	182.529	1705854.0
2018-08-24 12:00:00	QQQ	ETF	182.53	182.5799	182.39	182.49	699055.0
2018-08-24 12:30:00	QQQ	ETF	182.48	182.53	182.38	182.455	638127.0

> showing 50 of 15,831 rows — these rows as CSV

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