PREVIEW / etf_30min / 2018-09-07

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-07.parquet
  size:    467 KB
  rows:    15,975

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-09-07 04:00:00	SPY	ETF	287.97	287.97	287.77	287.83	6800.0
2018-09-07 04:30:00	SPY	ETF	287.91	287.91	287.71	287.71	40100.0
2018-09-07 05:00:00	SPY	ETF	287.65	288.03	287.65	287.92	16000.0
2018-09-07 05:30:00	SPY	ETF	287.86	287.86	287.46	287.52	25544.0
2018-09-07 06:00:00	SPY	ETF	287.54	287.61	287.46	287.61	8800.0
2018-09-07 06:30:00	SPY	ETF	287.65	287.83	287.65	287.79	23755.0
2018-09-07 07:00:00	SPY	ETF	287.74	287.85	287.68	287.77	49565.0
2018-09-07 07:30:00	SPY	ETF	287.74	287.8	287.61	287.65	50412.0
2018-09-07 08:00:00	SPY	ETF	287.64	288.11	287.57	287.72	136558.0
2018-09-07 08:30:00	SPY	ETF	287.66	287.88	286.99	287.03	798502.0
2018-09-07 09:00:00	SPY	ETF	287.03	287.21	286.82	286.99	414568.0
2018-09-07 09:30:00	SPY	ETF	286.98	287.99	286.71	287.78	7429507.0
2018-09-07 10:00:00	SPY	ETF	287.7738	288.36	287.64	288.0	3546847.0
2018-09-07 10:30:00	SPY	ETF	288.0	288.47	287.89	288.335	2909249.0
2018-09-07 11:00:00	SPY	ETF	288.34	288.45	288.12	288.42	2240047.0
2018-09-07 11:30:00	SPY	ETF	288.43	288.7	288.1	288.14	2636227.0
2018-09-07 12:00:00	SPY	ETF	288.14	288.22	287.05	287.13	9589467.0
2018-09-07 12:30:00	SPY	ETF	287.1201	287.67	286.92	287.58	4066989.0
2018-09-07 13:00:00	SPY	ETF	287.59	287.6	287.09	287.4	2102432.0
2018-09-07 13:30:00	SPY	ETF	287.41	287.51	287.11	287.15	1831476.0
2018-09-07 14:00:00	SPY	ETF	287.15	287.88	287.145	287.855	2324815.0
2018-09-07 14:30:00	SPY	ETF	287.85	287.95	287.56	287.91	2732773.0
2018-09-07 15:00:00	SPY	ETF	287.915	287.95	287.56	287.8	2631750.0
2018-09-07 15:30:00	SPY	ETF	287.8	287.86	287.22	287.56	14474212.0
2018-09-07 16:00:00	SPY	ETF	287.55	287.76	279.18	287.6	10558365.0
2018-09-07 16:30:00	SPY	ETF	287.68	287.68	287.44	287.5	201239.0
2018-09-07 17:00:00	SPY	ETF	287.52	287.59	287.45	287.56	30762.0
2018-09-07 17:30:00	SPY	ETF	287.57	287.66	287.37	287.53	1480465.0
2018-09-07 18:00:00	SPY	ETF	287.53	287.56	287.44	287.44	21165.0
2018-09-07 18:30:00	SPY	ETF	287.5	287.5	287.46	287.48	10670.0
2018-09-07 19:00:00	SPY	ETF	287.46	287.46	287.26	287.26	14383.0
2018-09-07 19:30:00	SPY	ETF	287.27	287.38	287.16	287.38	8282.0
2018-09-07 04:00:00	QQQ	ETF	181.5	181.6	181.5	181.54	20759.0
2018-09-07 04:30:00	QQQ	ETF	181.62	181.62	181.42	181.43	39593.0
2018-09-07 05:00:00	QQQ	ETF	181.39	181.65	181.35	181.65	5950.0
2018-09-07 05:30:00	QQQ	ETF	181.5	181.52	181.24	181.34	11713.0
2018-09-07 06:00:00	QQQ	ETF	181.31	181.31	181.29	181.29	5500.0
2018-09-07 06:30:00	QQQ	ETF	181.47	181.54	181.47	181.51	3164.0
2018-09-07 07:00:00	QQQ	ETF	181.44	181.54	181.42	181.45	18762.0
2018-09-07 07:30:00	QQQ	ETF	181.47	181.5	181.35	181.35	38700.0
2018-09-07 08:00:00	QQQ	ETF	181.48	181.72	181.29	181.45	35286.0
2018-09-07 08:30:00	QQQ	ETF	181.39	181.39	180.56	180.56	881893.0
2018-09-07 09:00:00	QQQ	ETF	180.54	180.6	180.23	180.54	750643.0
2018-09-07 09:30:00	QQQ	ETF	180.54	182.38	180.44	182.16	7521830.0
2018-09-07 10:00:00	QQQ	ETF	182.16	182.45	181.95	182.11	3058642.0
2018-09-07 10:30:00	QQQ	ETF	182.11	182.55	181.97	182.475	2385281.0
2018-09-07 11:00:00	QQQ	ETF	182.48	182.56	182.1199	182.39	1383213.0
2018-09-07 11:30:00	QQQ	ETF	182.39	182.67	182.05	182.07	1591305.0
2018-09-07 12:00:00	QQQ	ETF	182.06	182.13	181.07	181.235	4104238.0
2018-09-07 12:30:00	QQQ	ETF	181.235	182.0259	181.1799	181.92	1748092.0

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

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