PREVIEW / etf_30min / 2020-02-18

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-18.parquet
  size:    552 KB
  rows:    19,761

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-02-18 04:00:00	SPY	ETF	336.5	336.5	335.83	336.0	37271.0
2020-02-18 04:30:00	SPY	ETF	335.98	336.18	335.88	336.16	10943.0
2020-02-18 05:00:00	SPY	ETF	336.0	336.48	335.94	336.29	23900.0
2020-02-18 05:30:00	SPY	ETF	336.3	336.6	336.3	336.58	27686.0
2020-02-18 06:00:00	SPY	ETF	336.45	336.54	336.35	336.51	29053.0
2020-02-18 06:30:00	SPY	ETF	336.52	336.52	336.07	336.09	40666.0
2020-02-18 07:00:00	SPY	ETF	336.17	336.51	336.07	336.36	81255.0
2020-02-18 07:30:00	SPY	ETF	336.36	336.43	336.2	336.26	110805.0
2020-02-18 08:00:00	SPY	ETF	336.2	336.83	336.07	336.52	247616.0
2020-02-18 08:30:00	SPY	ETF	336.54	336.74	336.39	336.46	230210.0
2020-02-18 09:00:00	SPY	ETF	336.46	336.72	336.46	336.52	181554.0
2020-02-18 09:30:00	SPY	ETF	336.51	337.12	336.4	336.98	6579043.0
2020-02-18 10:00:00	SPY	ETF	336.98	337.1	335.945	335.99	4071211.0
2020-02-18 10:30:00	SPY	ETF	335.99	336.65	335.97	336.3835	4588424.0
2020-02-18 11:00:00	SPY	ETF	336.38	336.465	335.36	335.47	4787583.0
2020-02-18 11:30:00	SPY	ETF	335.47	335.78	335.23	335.255	4779435.0
2020-02-18 12:00:00	SPY	ETF	335.26	335.86	335.21	335.8	2287574.0
2020-02-18 12:30:00	SPY	ETF	335.8	337.6677	335.8	336.16	2350898.0
2020-02-18 13:00:00	SPY	ETF	336.165	336.5	336.15	336.38	1587047.0
2020-02-18 13:30:00	SPY	ETF	336.38	336.49	336.06	336.22	1388368.0
2020-02-18 14:00:00	SPY	ETF	336.23	336.95	335.96	336.88	3360517.0
2020-02-18 14:30:00	SPY	ETF	336.87	336.99	336.675	336.9	3346569.0
2020-02-18 15:00:00	SPY	ETF	336.92	337.17	336.72	336.85	3346020.0
2020-02-18 15:30:00	SPY	ETF	336.86	336.8699	336.41	336.7	6077153.0
2020-02-18 16:00:00	SPY	ETF	336.7	336.81	336.53	336.71	5873501.0
2020-02-18 16:30:00	SPY	ETF	336.7	336.84	336.59	336.76	751502.0
2020-02-18 17:00:00	SPY	ETF	336.7	336.83	336.7	336.81	51239.0
2020-02-18 17:30:00	SPY	ETF	336.83	336.88	336.82	336.88	40347.0
2020-02-18 18:00:00	SPY	ETF	336.86	337.08	336.8	337.07	50388.0
2020-02-18 18:30:00	SPY	ETF	337.08	337.5	337.03	337.44	32033.0
2020-02-18 19:00:00	SPY	ETF	337.47	337.6	337.27	337.34	23535.0
2020-02-18 19:30:00	SPY	ETF	337.37	337.4	337.22	337.25	32414.0
2020-02-18 04:00:00	QQQ	ETF	232.83	232.83	232.36	232.54	40573.0
2020-02-18 04:30:00	QQQ	ETF	232.47	232.63	232.47	232.54	11123.0
2020-02-18 05:00:00	QQQ	ETF	232.52	232.88	232.43	232.74	19791.0
2020-02-18 05:30:00	QQQ	ETF	232.74	233.07	232.73	233.0	14270.0
2020-02-18 06:00:00	QQQ	ETF	233.04	233.04	232.86	232.93	11059.0
2020-02-18 06:30:00	QQQ	ETF	232.95	232.95	232.73	232.74	21811.0
2020-02-18 07:00:00	QQQ	ETF	232.77	233.23	232.77	233.12	98844.0
2020-02-18 07:30:00	QQQ	ETF	233.12	233.23	233.0	233.14	58223.0
2020-02-18 08:00:00	QQQ	ETF	232.8999	234.64	232.26	233.36	249722.0
2020-02-18 08:30:00	QQQ	ETF	233.41	233.66	233.33	233.39	229152.0
2020-02-18 09:00:00	QQQ	ETF	233.39	233.67	233.36	233.44	130292.0
2020-02-18 09:30:00	QQQ	ETF	233.47	234.4	233.25	234.39	3816748.0
2020-02-18 10:00:00	QQQ	ETF	234.39	234.515	233.7	233.76	2700131.0
2020-02-18 10:30:00	QQQ	ETF	233.76	234.5	233.7506	234.3	1129478.0
2020-02-18 11:00:00	QQQ	ETF	234.31	234.39	233.56	233.6278	988046.0
2020-02-18 11:30:00	QQQ	ETF	233.63	233.82	233.32	233.4	1183377.0
2020-02-18 12:00:00	QQQ	ETF	233.395	233.837	233.33	233.81	901817.0
2020-02-18 12:30:00	QQQ	ETF	233.8	234.21	233.8	234.135	613978.0

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

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