PREVIEW / etf_30min / 2018-03-13

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-13.parquet
  size:    465 KB
  rows:    16,041

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-13 04:00:00	SPY	ETF	278.97	279.1	278.94	279.03	4181.0
2018-03-13 04:30:00	SPY	ETF	279.0	279.05	278.9	279.03	6110.0
2018-03-13 05:00:00	SPY	ETF	279.09	279.27	279.09	279.27	5420.0
2018-03-13 05:30:00	SPY	ETF	279.23	279.23	279.05	279.13	3100.0
2018-03-13 06:00:00	SPY	ETF	279.14	279.26	279.1	279.26	6760.0
2018-03-13 06:30:00	SPY	ETF	279.22	279.32	279.12	279.25	7756.0
2018-03-13 07:00:00	SPY	ETF	279.2	279.27	279.09	279.23	19771.0
2018-03-13 07:30:00	SPY	ETF	279.21	279.24	279.11	279.16	137460.0
2018-03-13 08:00:00	SPY	ETF	279.17	279.2	278.76	278.95	210401.0
2018-03-13 08:30:00	SPY	ETF	278.95	280.17	278.95	279.68	2123540.0
2018-03-13 09:00:00	SPY	ETF	279.66	279.95	279.4	279.84	776043.0
2018-03-13 09:30:00	SPY	ETF	279.84	280.41	279.56	279.9	6974121.0
2018-03-13 10:00:00	SPY	ETF	279.91	280.09	279.54	279.73	3873755.0
2018-03-13 10:30:00	SPY	ETF	279.74	279.775	279.0	279.025	4117791.0
2018-03-13 11:00:00	SPY	ETF	279.02	279.07	278.18	278.41	7234965.0
2018-03-13 11:30:00	SPY	ETF	278.42	278.63	278.01	278.2	6669445.0
2018-03-13 12:00:00	SPY	ETF	278.2	278.31	277.15	277.75	6491198.0
2018-03-13 12:30:00	SPY	ETF	277.745	278.39	277.72	278.18	3858789.0
2018-03-13 13:00:00	SPY	ETF	278.19	278.535	278.09	278.27	2171945.0
2018-03-13 13:30:00	SPY	ETF	278.2601	278.48	277.56	277.64	3279738.0
2018-03-13 14:00:00	SPY	ETF	277.635	277.91	277.23	277.4	3176774.0
2018-03-13 14:30:00	SPY	ETF	277.395	277.93	276.91	277.21	4273218.0
2018-03-13 15:00:00	SPY	ETF	277.21	277.49	276.34	276.49	8935987.0
2018-03-13 15:30:00	SPY	ETF	276.49	276.96	276.03	276.69	15218347.0
2018-03-13 16:00:00	SPY	ETF	276.69	277.1	276.69	276.95	8108855.0
2018-03-13 16:30:00	SPY	ETF	276.98	276.99	276.63	276.65	618437.0
2018-03-13 17:00:00	SPY	ETF	276.63	276.7	276.45	276.57	116869.0
2018-03-13 17:30:00	SPY	ETF	276.5	277.05	276.3	276.41	2086351.0
2018-03-13 18:00:00	SPY	ETF	276.45	276.45	276.0	276.35	185097.0
2018-03-13 18:30:00	SPY	ETF	276.34	276.54	276.31	276.5	30780.0
2018-03-13 19:00:00	SPY	ETF	276.53	276.58	276.36	276.46	21828.0
2018-03-13 19:30:00	SPY	ETF	276.47	276.65	276.42	276.55	24701.0
2018-03-13 04:00:00	QQQ	ETF	174.2	174.2	174.06	174.11	22750.0
2018-03-13 04:30:00	QQQ	ETF	174.08	174.1	174.07	174.1	4300.0
2018-03-13 05:00:00	QQQ	ETF	174.22	174.26	174.22	174.24	1100.0
2018-03-13 05:30:00	QQQ	ETF	174.23	174.23	174.09	174.14	5300.0
2018-03-13 06:00:00	QQQ	ETF	174.13	174.24	174.13	174.22	8600.0
2018-03-13 06:30:00	QQQ	ETF	174.18	174.24	174.16	174.24	8720.0
2018-03-13 07:00:00	QQQ	ETF	174.26	174.27	174.17	174.24	26204.0
2018-03-13 07:30:00	QQQ	ETF	174.25	174.29	174.21	174.27	79665.0
2018-03-13 08:00:00	QQQ	ETF	174.21	174.28	173.85	174.15	79279.0
2018-03-13 08:30:00	QQQ	ETF	174.16	174.9	174.13	174.7	568694.0
2018-03-13 09:00:00	QQQ	ETF	174.69	174.93	174.55	174.78	168127.0
2018-03-13 09:30:00	QQQ	ETF	174.8	175.21	174.7	174.79	3517005.0
2018-03-13 10:00:00	QQQ	ETF	174.8	175.06	174.56	174.74	1919615.0
2018-03-13 10:30:00	QQQ	ETF	174.74	174.76	173.85	173.88	2588446.0
2018-03-13 11:00:00	QQQ	ETF	173.89	173.91	172.804	172.98	4156901.0
2018-03-13 11:30:00	QQQ	ETF	172.99	173.34	172.72	173.0201	2958603.0
2018-03-13 12:00:00	QQQ	ETF	173.02	173.08	171.96	172.67	4022239.0
2018-03-13 12:30:00	QQQ	ETF	172.67	173.09	172.57	172.94	1666382.0

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

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