PREVIEW / etf_30min / 2020-08-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-21.parquet
  size:    539 KB
  rows:    19,844

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-08-21 04:00:00	SPY	ETF	338.35	338.35	337.94	338.05	12124.0
2020-08-21 04:30:00	SPY	ETF	337.9	338.01	337.65	337.85	17461.0
2020-08-21 05:00:00	SPY	ETF	337.81	338.16	337.69	338.16	3915.0
2020-08-21 05:30:00	SPY	ETF	338.13	338.32	338.04	338.27	9528.0
2020-08-21 06:00:00	SPY	ETF	338.27	338.31	337.88	337.91	14493.0
2020-08-21 06:30:00	SPY	ETF	337.95	337.98	337.35	337.56	50714.0
2020-08-21 07:00:00	SPY	ETF	337.57	337.69	337.36	337.46	106577.0
2020-08-21 07:30:00	SPY	ETF	337.44	337.54	336.24	336.3	459208.0
2020-08-21 08:00:00	SPY	ETF	336.3	338.29	335.75	336.48	758784.0
2020-08-21 08:30:00	SPY	ETF	336.5	338.94	336.34	336.86	242337.0
2020-08-21 09:00:00	SPY	ETF	336.85	338.0	336.57	337.93	539578.0
2020-08-21 09:30:00	SPY	ETF	337.92	338.67	337.55	338.62	6325629.0
2020-08-21 10:00:00	SPY	ETF	338.635	338.79	337.93	338.48	4182511.0
2020-08-21 10:30:00	SPY	ETF	338.4868	338.94	338.42	338.6318	2155074.0
2020-08-21 11:00:00	SPY	ETF	338.61	338.69	338.18	338.55	2070151.0
2020-08-21 11:30:00	SPY	ETF	338.56	338.65	337.9	337.97	4877013.0
2020-08-21 12:00:00	SPY	ETF	337.965	338.79	337.92	338.66	1467533.0
2020-08-21 12:30:00	SPY	ETF	338.665	338.75	338.48	338.57	1459050.0
2020-08-21 13:00:00	SPY	ETF	338.57	338.7596	338.33	338.58	2510646.0
2020-08-21 13:30:00	SPY	ETF	338.57	338.96	338.52	338.845	2021751.0
2020-08-21 14:00:00	SPY	ETF	338.8485	339.07	338.68	339.05	1443566.0
2020-08-21 14:30:00	SPY	ETF	339.05	339.46	339.045	339.345	2546898.0
2020-08-21 15:00:00	SPY	ETF	339.34	339.72	339.32	339.49	4759969.0
2020-08-21 15:30:00	SPY	ETF	339.4816	339.67	339.12	339.44	7125292.0
2020-08-21 16:00:00	SPY	ETF	339.43	339.66	339.238	339.39	7626738.0
2020-08-21 16:30:00	SPY	ETF	339.39	339.52	339.27	339.33	811083.0
2020-08-21 17:00:00	SPY	ETF	339.28	339.65	339.06	339.6	312165.0
2020-08-21 17:30:00	SPY	ETF	339.6	339.66	339.58	339.58	94374.0
2020-08-21 18:00:00	SPY	ETF	339.57	339.64	339.56	339.59	5192.0
2020-08-21 18:30:00	SPY	ETF	339.63	339.68	339.59	339.61	12412.0
2020-08-21 19:00:00	SPY	ETF	339.62	339.67	339.59	339.6	6454.0
2020-08-21 19:30:00	SPY	ETF	339.59	339.65	339.5	339.65	11364.0
2020-08-21 04:00:00	QQQ	ETF	280.23	280.23	279.8	279.84	31193.0
2020-08-21 04:30:00	QQQ	ETF	279.85	279.91	279.65	279.72	12786.0
2020-08-21 05:00:00	QQQ	ETF	279.99	280.19	279.97	280.13	7076.0
2020-08-21 05:30:00	QQQ	ETF	280.05	280.39	280.05	280.29	12979.0
2020-08-21 06:00:00	QQQ	ETF	280.26	280.32	279.86	279.9	27292.0
2020-08-21 06:30:00	QQQ	ETF	279.95	279.95	279.21	279.62	39991.0
2020-08-21 07:00:00	QQQ	ETF	279.64	279.88	279.6	279.67	140369.0
2020-08-21 07:30:00	QQQ	ETF	279.7	279.77	278.79	278.88	241010.0
2020-08-21 08:00:00	QQQ	ETF	278.85	280.7	278.27	279.0	289898.0
2020-08-21 08:30:00	QQQ	ETF	278.98	279.79	278.92	279.65	136804.0
2020-08-21 09:00:00	QQQ	ETF	279.62	280.53	279.31	280.11	743471.0
2020-08-21 09:30:00	QQQ	ETF	280.07	280.65	279.461	280.43	3943920.0
2020-08-21 10:00:00	QQQ	ETF	280.4334	281.23	279.76	281.1217	2499289.0
2020-08-21 10:30:00	QQQ	ETF	281.16	281.97	281.12	281.675	1987556.0
2020-08-21 11:00:00	QQQ	ETF	281.67	281.755	280.815	281.5	1606338.0
2020-08-21 11:30:00	QQQ	ETF	281.49	281.51	280.22	280.35	1475137.0
2020-08-21 12:00:00	QQQ	ETF	280.34	281.5199	280.22	281.51	1107702.0
2020-08-21 12:30:00	QQQ	ETF	281.51	281.6	281.19	281.5	818496.0

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

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