PREVIEW / etf_30min / 2020-01-09

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-09.parquet
  size:    545 KB
  rows:    19,130

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-09 04:00:00	SPY	ETF	326.12	326.23	326.03	326.03	6061.0
2020-01-09 04:30:00	SPY	ETF	326.11	326.15	326.02	326.15	3214.0
2020-01-09 05:00:00	SPY	ETF	326.14	326.29	326.1	326.1	12440.0
2020-01-09 05:30:00	SPY	ETF	326.05	326.16	326.0	326.0	15910.0
2020-01-09 06:00:00	SPY	ETF	326.05	326.16	326.03	326.16	14499.0
2020-01-09 06:30:00	SPY	ETF	326.13	326.22	326.12	326.21	25875.0
2020-01-09 07:00:00	SPY	ETF	326.19	326.37	325.98	326.16	83362.0
2020-01-09 07:30:00	SPY	ETF	326.12	326.12	325.76	325.94	206415.0
2020-01-09 08:00:00	SPY	ETF	326.2	326.36	325.29	326.06	142696.0
2020-01-09 08:30:00	SPY	ETF	326.06	326.27	326.06	326.16	135116.0
2020-01-09 09:00:00	SPY	ETF	326.17	326.26	326.03	326.18	219778.0
2020-01-09 09:30:00	SPY	ETF	326.16	326.47	325.65	326.01	5569660.0
2020-01-09 10:00:00	SPY	ETF	325.985	326.2104	325.71	326.17	1926502.0
2020-01-09 10:30:00	SPY	ETF	326.17	326.5598	326.13	326.4595	2486135.0
2020-01-09 11:00:00	SPY	ETF	326.47	326.54	326.09	326.2	2420380.0
2020-01-09 11:30:00	SPY	ETF	326.21	326.6	326.19	326.52	3549409.0
2020-01-09 12:00:00	SPY	ETF	326.53	326.61	325.96	326.06	2517272.0
2020-01-09 12:30:00	SPY	ETF	326.06	326.07	325.52	326.04	4002224.0
2020-01-09 13:00:00	SPY	ETF	326.05	326.15	325.75	326.1	3011195.0
2020-01-09 13:30:00	SPY	ETF	326.095	326.44	325.99	326.19	1949597.0
2020-01-09 14:00:00	SPY	ETF	326.19	326.42	326.17	326.367	2723112.0
2020-01-09 14:30:00	SPY	ETF	326.3687	326.73	326.35	326.5	2475199.0
2020-01-09 15:00:00	SPY	ETF	326.49	326.5096	326.115	326.305	2323771.0
2020-01-09 15:30:00	SPY	ETF	326.3	326.68	326.16	326.62	8410612.0
2020-01-09 16:00:00	SPY	ETF	326.62	326.75	326.52	326.61	2909136.0
2020-01-09 16:30:00	SPY	ETF	326.61	326.65	326.56	326.59	222556.0
2020-01-09 17:00:00	SPY	ETF	326.59	326.6	326.43	326.47	297389.0
2020-01-09 17:30:00	SPY	ETF	326.52	326.6	326.49	326.57	39630.0
2020-01-09 18:00:00	SPY	ETF	326.6	326.98	326.6	326.9	70642.0
2020-01-09 18:30:00	SPY	ETF	326.92	326.92	326.86	326.9	13746.0
2020-01-09 19:00:00	SPY	ETF	326.88	327.05	326.83	326.99	18212.0
2020-01-09 19:30:00	SPY	ETF	327.0	327.36	327.0	327.22	43426.0
2020-01-09 04:00:00	QQQ	ETF	218.42	218.59	218.42	218.45	23327.0
2020-01-09 04:30:00	QQQ	ETF	218.5	218.55	218.45	218.5	6940.0
2020-01-09 05:00:00	QQQ	ETF	218.53	218.61	218.42	218.42	14908.0
2020-01-09 05:30:00	QQQ	ETF	218.4	218.48	218.37	218.39	15218.0
2020-01-09 06:00:00	QQQ	ETF	218.38	218.48	218.36	218.46	15380.0
2020-01-09 06:30:00	QQQ	ETF	218.48	218.55	218.43	218.49	17070.0
2020-01-09 07:00:00	QQQ	ETF	218.49	218.74	218.4	218.5	95745.0
2020-01-09 07:30:00	QQQ	ETF	218.52	218.52	218.27	218.45	67077.0
2020-01-09 08:00:00	QQQ	ETF	218.43	218.72	217.72	218.68	112513.0
2020-01-09 08:30:00	QQQ	ETF	218.74	218.85	218.71	218.76	171578.0
2020-01-09 09:00:00	QQQ	ETF	218.77	218.97	218.68	218.92	621896.0
2020-01-09 09:30:00	QQQ	ETF	218.9	219.41	218.78	218.96	3270726.0
2020-01-09 10:00:00	QQQ	ETF	218.97	219.12	218.69	218.995	1545061.0
2020-01-09 10:30:00	QQQ	ETF	218.99	219.3	218.9301	219.1519	852007.0
2020-01-09 11:00:00	QQQ	ETF	219.16	219.1979	218.7299	218.8422	968623.0
2020-01-09 11:30:00	QQQ	ETF	218.86	219.18	218.83	219.04	963694.0
2020-01-09 12:00:00	QQQ	ETF	219.04	219.09	218.34	218.46	978265.0
2020-01-09 12:30:00	QQQ	ETF	218.45	218.45	217.7125	218.39	1893702.0

> showing 50 of 19,130 rows — these rows as CSV

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