PREVIEW / etf_30min / 2018-12-03

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-03.parquet
  size:    514 KB
  rows:    18,037

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-12-03 04:00:00	SPY	ETF	281.0	281.27	280.1	280.82	63838.0
2018-12-03 04:30:00	SPY	ETF	280.79	281.03	280.76	281.03	33710.0
2018-12-03 05:00:00	SPY	ETF	281.03	281.1	280.82	281.02	21817.0
2018-12-03 05:30:00	SPY	ETF	280.98	280.99	280.61	280.68	33763.0
2018-12-03 06:00:00	SPY	ETF	280.92	281.27	280.1	280.47	258867.0
2018-12-03 06:30:00	SPY	ETF	280.47	280.47	280.13	280.29	65079.0
2018-12-03 07:00:00	SPY	ETF	280.2	280.28	279.69	279.97	595276.0
2018-12-03 07:30:00	SPY	ETF	280.0	280.2	279.87	279.9	419640.0
2018-12-03 08:00:00	SPY	ETF	280.25	281.28	275.65	280.05	628259.0
2018-12-03 08:30:00	SPY	ETF	280.03	280.21	279.77	280.02	700446.0
2018-12-03 09:00:00	SPY	ETF	280.02	281.0	279.89	280.3	1271612.0
2018-12-03 09:30:00	SPY	ETF	280.28	280.4	278.63	278.92	12083217.0
2018-12-03 10:00:00	SPY	ETF	278.94	279.76	278.67	279.57	9252634.0
2018-12-03 10:30:00	SPY	ETF	279.57	279.6111	278.03	278.17	6700941.0
2018-12-03 11:00:00	SPY	ETF	278.17	278.7	277.78	278.3	7502952.0
2018-12-03 11:30:00	SPY	ETF	278.3	278.59	277.505	277.68	5002022.0
2018-12-03 12:00:00	SPY	ETF	277.69	278.56	277.67	278.56	3738594.0
2018-12-03 12:30:00	SPY	ETF	278.54	279.02	278.23	278.5075	2866425.0
2018-12-03 13:00:00	SPY	ETF	278.5061	279.22	278.5061	279.04	4476797.0
2018-12-03 13:30:00	SPY	ETF	279.03	279.03	277.99	278.2925	4122281.0
2018-12-03 14:00:00	SPY	ETF	278.3	278.86	277.65	278.74	5669018.0
2018-12-03 14:30:00	SPY	ETF	278.74	278.92	278.37	278.6044	3947188.0
2018-12-03 15:00:00	SPY	ETF	278.6	279.36	278.23	279.15	7780377.0
2018-12-03 15:30:00	SPY	ETF	279.16	279.4676	278.6	279.23	13010073.0
2018-12-03 16:00:00	SPY	ETF	279.22	279.56	278.93	279.28	9493060.0
2018-12-03 16:30:00	SPY	ETF	279.28	279.3	279.0	279.08	2163393.0
2018-12-03 17:00:00	SPY	ETF	279.11	279.26	279.11	279.17	43229.0
2018-12-03 17:30:00	SPY	ETF	279.2	279.22	279.06	279.08	73311.0
2018-12-03 18:00:00	SPY	ETF	279.07	279.08	278.73	278.85	98935.0
2018-12-03 18:30:00	SPY	ETF	278.84	278.94	278.75	278.8	41163.0
2018-12-03 19:00:00	SPY	ETF	278.85	278.85	278.61	278.8	15214.0
2018-12-03 19:30:00	SPY	ETF	278.77	278.9	278.48	278.49	35797.0
2018-12-03 04:00:00	QQQ	ETF	173.6	173.87	173.59	173.63	53689.0
2018-12-03 04:30:00	QQQ	ETF	173.59	173.87	173.59	173.87	22242.0
2018-12-03 05:00:00	QQQ	ETF	173.83	173.88	173.7	173.76	68513.0
2018-12-03 05:30:00	QQQ	ETF	173.75	173.75	173.5	173.58	43348.0
2018-12-03 06:00:00	QQQ	ETF	173.56	173.57	173.38	173.42	72622.0
2018-12-03 06:30:00	QQQ	ETF	173.42	173.42	173.21	173.29	63919.0
2018-12-03 07:00:00	QQQ	ETF	173.28	173.3	172.97	173.2	225678.0
2018-12-03 07:30:00	QQQ	ETF	173.2	173.27	173.04	173.2	123847.0
2018-12-03 08:00:00	QQQ	ETF	173.05	173.98	173.0	173.1	352562.0
2018-12-03 08:30:00	QQQ	ETF	173.1	173.1	172.73	172.87	522324.0
2018-12-03 09:00:00	QQQ	ETF	172.85	173.14	172.82	173.1	356030.0
2018-12-03 09:30:00	QQQ	ETF	173.09	173.31	171.5	171.87	6782260.0
2018-12-03 10:00:00	QQQ	ETF	171.88	173.12	171.78	172.79	6589438.0
2018-12-03 10:30:00	QQQ	ETF	172.8	172.85	171.62	171.7	3557791.0
2018-12-03 11:00:00	QQQ	ETF	171.7	172.29	171.4301	172.06	2935350.0
2018-12-03 11:30:00	QQQ	ETF	172.07	172.28	171.3	171.4	1981972.0
2018-12-03 12:00:00	QQQ	ETF	171.4	171.91	171.39	171.88	1286325.0
2018-12-03 12:30:00	QQQ	ETF	171.87	172.21	171.6	171.85	1560627.0

> showing 50 of 18,037 rows — these rows as CSV

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