PREVIEW / etf_30min / 2020-01-15

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-15.parquet
  size:    536 KB
  rows:    18,871

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
2020-01-15 04:00:00	SPY	ETF	327.46	327.5	327.37	327.46	2654.0
2020-01-15 04:30:00	SPY	ETF	327.47	327.56	327.41	327.41	1700.0
2020-01-15 05:00:00	SPY	ETF	327.51	327.68	327.47	327.66	8137.0
2020-01-15 05:30:00	SPY	ETF	327.66	327.66	327.52	327.66	6200.0
2020-01-15 06:00:00	SPY	ETF	327.66	327.75	327.66	327.69	2504.0
2020-01-15 06:30:00	SPY	ETF	327.72	327.89	327.64	327.77	20624.0
2020-01-15 07:00:00	SPY	ETF	327.77	327.86	327.6	327.63	75267.0
2020-01-15 07:30:00	SPY	ETF	327.61	327.9	327.58	327.86	23163.0
2020-01-15 08:00:00	SPY	ETF	327.78	327.94	327.15	327.67	150442.0
2020-01-15 08:30:00	SPY	ETF	327.7	327.77	327.05	327.12	172903.0
2020-01-15 09:00:00	SPY	ETF	327.08	327.37	327.04	327.34	152394.0
2020-01-15 09:30:00	SPY	ETF	327.35	328.66	327.3	328.59	4679262.0
2020-01-15 10:00:00	SPY	ETF	328.61	328.8	328.295	328.48	2673246.0
2020-01-15 10:30:00	SPY	ETF	328.49	328.9	328.35	328.89	2696796.0
2020-01-15 11:00:00	SPY	ETF	328.89	328.98	328.33	328.64	4013213.0
2020-01-15 11:30:00	SPY	ETF	328.64	329.02	328.47	328.64	3062505.0
2020-01-15 12:00:00	SPY	ETF	328.65	328.87	328.53	328.62	3719757.0
2020-01-15 12:30:00	SPY	ETF	328.63	328.8	328.1	328.16	5234461.0
2020-01-15 13:00:00	SPY	ETF	328.16	328.27	327.95	328.14	4253945.0
2020-01-15 13:30:00	SPY	ETF	328.14	328.25	327.73	327.93	4339348.0
2020-01-15 14:00:00	SPY	ETF	327.93	328.66	327.88	328.63	5213326.0
2020-01-15 14:30:00	SPY	ETF	328.64	328.66	328.235	328.255	3051617.0
2020-01-15 15:00:00	SPY	ETF	328.26	328.285	327.42	327.6625	5282152.0
2020-01-15 15:30:00	SPY	ETF	327.67	328.18	327.26	328.17	10325251.0
2020-01-15 16:00:00	SPY	ETF	328.17	328.5	327.4858	328.42	6486458.0
2020-01-15 16:30:00	SPY	ETF	328.42	328.5	327.4858	328.5	1715409.0
2020-01-15 17:00:00	SPY	ETF	328.49	328.55	328.19	328.51	1066717.0
2020-01-15 17:30:00	SPY	ETF	328.51	328.54	328.48	328.48	657578.0
2020-01-15 18:00:00	SPY	ETF	328.54	329.04	328.54	328.89	100582.0
2020-01-15 18:30:00	SPY	ETF	328.9	328.93	328.78	328.78	30129.0
2020-01-15 19:00:00	SPY	ETF	328.78	328.85	328.63	328.7	21447.0
2020-01-15 19:30:00	SPY	ETF	328.7	328.79	328.62	328.66	24754.0
2020-01-15 04:00:00	QQQ	ETF	220.04	220.06	219.98	219.98	5842.0
2020-01-15 04:30:00	QQQ	ETF	220.07	220.1	220.01	220.06	3400.0
2020-01-15 05:00:00	QQQ	ETF	220.1	220.24	220.1	220.22	11303.0
2020-01-15 05:30:00	QQQ	ETF	220.23	220.26	220.14	220.21	5133.0
2020-01-15 06:00:00	QQQ	ETF	220.33	220.33	220.19	220.19	1724.0
2020-01-15 06:30:00	QQQ	ETF	220.23	220.38	220.23	220.35	9940.0
2020-01-15 07:00:00	QQQ	ETF	220.31	220.5	220.3	220.3	42049.0
2020-01-15 07:30:00	QQQ	ETF	220.3	220.68	220.29	220.6	45860.0
2020-01-15 08:00:00	QQQ	ETF	220.37	220.64	220.29	220.51	45488.0
2020-01-15 08:30:00	QQQ	ETF	220.49	220.58	219.94	220.1	143108.0
2020-01-15 09:00:00	QQQ	ETF	219.98	220.22	219.98	220.16	316028.0
2020-01-15 09:30:00	QQQ	ETF	220.17	220.9625	220.12	220.91	2801126.0
2020-01-15 10:00:00	QQQ	ETF	220.94	221.09	220.64	220.82	1007257.0
2020-01-15 10:30:00	QQQ	ETF	220.835	221.2	220.73	221.17	915422.0
2020-01-15 11:00:00	QQQ	ETF	221.17	221.18	220.61	220.74	1034994.0
2020-01-15 11:30:00	QQQ	ETF	220.73	220.99	220.6	220.75	868918.0
2020-01-15 12:00:00	QQQ	ETF	220.76	221.03	220.7	220.83	663619.0
2020-01-15 12:30:00	QQQ	ETF	220.83	220.94	220.43	220.48	1123675.0

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

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