PREVIEW / etf_30min / 2021-07-14

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-14.parquet
  size:    598 KB
  rows:    22,884

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
2021-07-14 04:00:00	SPY	ETF	435.12	435.5	434.8	435.32	8825.0
2021-07-14 04:30:00	SPY	ETF	435.42	435.51	435.14	435.26	5210.0
2021-07-14 05:00:00	SPY	ETF	435.56	435.76	435.51	435.71	18549.0
2021-07-14 05:30:00	SPY	ETF	435.83	436.0	435.68	435.69	25745.0
2021-07-14 06:00:00	SPY	ETF	435.69	435.87	435.69	435.81	8283.0
2021-07-14 06:30:00	SPY	ETF	435.82	436.01	435.8	435.87	4161.0
2021-07-14 07:00:00	SPY	ETF	435.8	436.11	435.8	436.02	51951.0
2021-07-14 07:30:00	SPY	ETF	436.04	436.38	435.97	436.33	71424.0
2021-07-14 08:00:00	SPY	ETF	435.9201	436.37	435.07	436.14	129391.0
2021-07-14 08:30:00	SPY	ETF	436.02	437.5	436.01	437.31	520058.0
2021-07-14 09:00:00	SPY	ETF	437.34	437.44	437.15	437.37	204970.0
2021-07-14 09:30:00	SPY	ETF	437.39	437.92	436.93	437.01	5147508.0
2021-07-14 10:00:00	SPY	ETF	437.02	437.45	436.7	436.79	2613673.0
2021-07-14 10:30:00	SPY	ETF	436.8	437.32	436.51	437.01	2295814.0
2021-07-14 11:00:00	SPY	ETF	436.9989	437.0281	435.7	435.9	3209873.0
2021-07-14 11:30:00	SPY	ETF	435.9	436.025	434.91	434.99	3924713.0
2021-07-14 12:00:00	SPY	ETF	434.99	436.395	434.96	436.33	3096179.0
2021-07-14 12:30:00	SPY	ETF	436.335	436.7699	436.2308	436.5	2084932.0
2021-07-14 13:00:00	SPY	ETF	436.5082	436.59	435.82	435.98	1724284.0
2021-07-14 13:30:00	SPY	ETF	435.97	436.635	435.92	436.48	1823108.0
2021-07-14 14:00:00	SPY	ETF	436.49	436.97	436.38	436.73	1935416.0
2021-07-14 14:30:00	SPY	ETF	436.74	436.855	436.452	436.62	1630365.0
2021-07-14 15:00:00	SPY	ETF	436.62	437.08	436.2	436.27	2588083.0
2021-07-14 15:30:00	SPY	ETF	436.26	436.66	436.005	436.22	11321183.0
2021-07-14 16:00:00	SPY	ETF	436.21	436.54	436.21	436.36	2382798.0
2021-07-14 16:30:00	SPY	ETF	436.35	436.39	436.04	436.08	210406.0
2021-07-14 17:00:00	SPY	ETF	436.13	436.19	436.1	436.14	36691.0
2021-07-14 17:30:00	SPY	ETF	436.11	436.19	436.11	436.13	19995.0
2021-07-14 18:00:00	SPY	ETF	436.12	436.28	435.99	436.28	65033.0
2021-07-14 18:30:00	SPY	ETF	436.24	436.27	436.16	436.19	23262.0
2021-07-14 19:00:00	SPY	ETF	436.17	436.3	436.17	436.2	39909.0
2021-07-14 19:30:00	SPY	ETF	436.2	436.23	436.04	436.23	15538.0
2021-07-14 04:00:00	QQQ	ETF	362.47	362.7	362.17	362.7	15965.0
2021-07-14 04:30:00	QQQ	ETF	362.71	362.9	362.61	362.8	8308.0
2021-07-14 05:00:00	QQQ	ETF	362.89	363.61	362.89	363.61	82596.0
2021-07-14 05:30:00	QQQ	ETF	363.68	363.9	363.51	363.53	93182.0
2021-07-14 06:00:00	QQQ	ETF	363.5	363.56	363.42	363.42	6136.0
2021-07-14 06:30:00	QQQ	ETF	363.48	363.64	363.44	363.52	16640.0
2021-07-14 07:00:00	QQQ	ETF	363.51	363.74	363.25	363.59	55227.0
2021-07-14 07:30:00	QQQ	ETF	363.59	364.06	363.42	364.03	94900.0
2021-07-14 08:00:00	QQQ	ETF	363.4304	364.08	362.63	363.77	85731.0
2021-07-14 08:30:00	QQQ	ETF	363.85	364.92	363.65	364.79	372062.0
2021-07-14 09:00:00	QQQ	ETF	364.77	364.92	364.55	364.82	202962.0
2021-07-14 09:30:00	QQQ	ETF	364.81	365.375	364.02	364.2506	4253189.0
2021-07-14 10:00:00	QQQ	ETF	364.27	365.49	364.21	364.46	2560698.0
2021-07-14 10:30:00	QQQ	ETF	364.47	365.331	364.06	365.14	2121598.0
2021-07-14 11:00:00	QQQ	ETF	365.1499	365.27	363.34	363.6	2260459.0
2021-07-14 11:30:00	QQQ	ETF	363.59	363.8572	362.22	362.2939	2724115.0
2021-07-14 12:00:00	QQQ	ETF	362.2902	363.9	362.24	363.74	1914300.0
2021-07-14 12:30:00	QQQ	ETF	363.72	364.27	363.5111	363.93	1337289.0

> showing 50 of 22,884 rows — these rows as CSV

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