PREVIEW / etf_30min / 2019-03-01

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-01.parquet
  size:    501 KB
  rows:    17,455

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
2019-03-01 04:00:00	SPY	ETF	280.1	280.2	280.08	280.2	5055.0
2019-03-01 04:30:00	SPY	ETF	280.18	280.24	280.16	280.21	3855.0
2019-03-01 05:00:00	SPY	ETF	280.16	280.17	280.08	280.17	3230.0
2019-03-01 05:30:00	SPY	ETF	280.17	280.17	280.06	280.11	7650.0
2019-03-01 06:00:00	SPY	ETF	280.06	280.19	280.06	280.11	4910.0
2019-03-01 06:30:00	SPY	ETF	280.19	280.23	280.13	280.23	20574.0
2019-03-01 07:00:00	SPY	ETF	280.22	280.37	280.19	280.25	81810.0
2019-03-01 07:30:00	SPY	ETF	280.23	280.38	280.21	280.3	83325.0
2019-03-01 08:00:00	SPY	ETF	280.28	280.37	279.61	280.1	188379.0
2019-03-01 08:30:00	SPY	ETF	280.03	280.2	280.03	280.15	182869.0
2019-03-01 09:00:00	SPY	ETF	280.13	280.51	280.1	280.46	628042.0
2019-03-01 09:30:00	SPY	ETF	280.44	280.88	280.41	280.79	7902127.0
2019-03-01 10:00:00	SPY	ETF	280.73	280.79	279.55	279.76	6764663.0
2019-03-01 10:30:00	SPY	ETF	279.75	279.94	279.52	279.82	3614448.0
2019-03-01 11:00:00	SPY	ETF	279.82	279.93	279.22	279.37	4193847.0
2019-03-01 11:30:00	SPY	ETF	279.37	279.53	278.82	279.1	3587946.0
2019-03-01 12:00:00	SPY	ETF	279.1	279.54	279.04	279.51	2853938.0
2019-03-01 12:30:00	SPY	ETF	279.505	279.75	279.385	279.68	2641345.0
2019-03-01 13:00:00	SPY	ETF	279.68	279.88	279.62	279.695	2691472.0
2019-03-01 13:30:00	SPY	ETF	279.7	279.87	279.7	279.7385	1629662.0
2019-03-01 14:00:00	SPY	ETF	279.735	280.44	279.69	280.4201	3789106.0
2019-03-01 14:30:00	SPY	ETF	280.43	280.45	280.15	280.33	3668029.0
2019-03-01 15:00:00	SPY	ETF	280.325	280.35	280.07	280.23	4310022.0
2019-03-01 15:30:00	SPY	ETF	280.24	280.76	280.14	280.49	15719796.0
2019-03-01 16:00:00	SPY	ETF	280.49	280.58	280.115	280.53	9517173.0
2019-03-01 16:30:00	SPY	ETF	280.53	280.75	280.42	280.7	692534.0
2019-03-01 17:00:00	SPY	ETF	280.71	280.75	280.53	280.58	86610.0
2019-03-01 17:30:00	SPY	ETF	280.6	280.65	280.58	280.65	154840.0
2019-03-01 18:00:00	SPY	ETF	280.64	280.68	280.59	280.6	8351.0
2019-03-01 18:30:00	SPY	ETF	280.6	280.75	280.56	280.74	1109521.0
2019-03-01 19:00:00	SPY	ETF	280.7	280.72	280.68	280.72	4726.0
2019-03-01 19:30:00	SPY	ETF	280.73	280.76	280.7	280.73	20371.0
2019-03-01 04:00:00	QQQ	ETF	174.29	174.46	174.29	174.46	12817.0
2019-03-01 04:30:00	QQQ	ETF	174.44	174.49	174.33	174.34	9370.0
2019-03-01 05:00:00	QQQ	ETF	174.38	174.39	174.38	174.39	2000.0
2019-03-01 05:30:00	QQQ	ETF	174.27	174.38	174.27	174.38	5700.0
2019-03-01 06:00:00	QQQ	ETF	174.38	174.38	174.32	174.37	2700.0
2019-03-01 06:30:00	QQQ	ETF	174.39	174.49	174.35	174.44	26225.0
2019-03-01 07:00:00	QQQ	ETF	174.43	174.48	174.34	174.41	57205.0
2019-03-01 07:30:00	QQQ	ETF	174.36	174.45	174.33	174.4	95737.0
2019-03-01 08:00:00	QQQ	ETF	174.41	174.47	173.94	174.27	181271.0
2019-03-01 08:30:00	QQQ	ETF	174.24	174.31	174.19	174.25	150887.0
2019-03-01 09:00:00	QQQ	ETF	174.28	174.53	174.21	174.42	455999.0
2019-03-01 09:30:00	QQQ	ETF	174.41	174.57	174.16	174.3525	4381508.0
2019-03-01 10:00:00	QQQ	ETF	174.35	174.35	173.55	173.7	3237507.0
2019-03-01 10:30:00	QQQ	ETF	173.71	174.01	173.61	173.94	1483729.0
2019-03-01 11:00:00	QQQ	ETF	173.95	173.9817	173.46	173.6049	1170814.0
2019-03-01 11:30:00	QQQ	ETF	173.6	173.688	173.18	173.44	1232104.0
2019-03-01 12:00:00	QQQ	ETF	173.44	173.83	173.4	173.81	1193912.0
2019-03-01 12:30:00	QQQ	ETF	173.81	173.98	173.77	173.9251	1308846.0

> showing 50 of 17,455 rows — these rows as CSV

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