PREVIEW / etf_30min / 2021-06-25

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-25.parquet
  size:    587 KB
  rows:    22,603

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-06-25 04:00:00	SPY	ETF	425.3	425.43	425.04	425.28	10701.0
2021-06-25 04:30:00	SPY	ETF	425.37	425.42	425.26	425.42	3197.0
2021-06-25 05:00:00	SPY	ETF	425.29	425.32	425.27	425.27	7150.0
2021-06-25 05:30:00	SPY	ETF	425.29	425.65	425.29	425.59	8590.0
2021-06-25 06:00:00	SPY	ETF	425.54	425.54	425.37	425.4	8233.0
2021-06-25 06:30:00	SPY	ETF	425.45	425.66	425.45	425.66	7188.0
2021-06-25 07:00:00	SPY	ETF	425.61	425.69	425.52	425.62	23068.0
2021-06-25 07:30:00	SPY	ETF	425.64	425.64	425.23	425.31	29891.0
2021-06-25 08:00:00	SPY	ETF	425.31	425.81	425.12	425.39	41252.0
2021-06-25 08:30:00	SPY	ETF	425.31	425.99	425.28	425.82	154362.0
2021-06-25 09:00:00	SPY	ETF	425.83	426.0	425.83	425.92	132201.0
2021-06-25 09:30:00	SPY	ETF	425.9	426.11	425.55	425.84	4635711.0
2021-06-25 10:00:00	SPY	ETF	425.84	426.48	425.6101	426.36	2735800.0
2021-06-25 10:30:00	SPY	ETF	426.36	426.445	425.87	425.9	2102921.0
2021-06-25 11:00:00	SPY	ETF	425.9	426.31	425.85	426.29	1490737.0
2021-06-25 11:30:00	SPY	ETF	426.31	426.36	426.145	426.3	1313644.0
2021-06-25 12:00:00	SPY	ETF	426.2902	426.38	426.08	426.1	1024071.0
2021-06-25 12:30:00	SPY	ETF	426.11	426.35	426.09	426.2816	1005398.0
2021-06-25 13:00:00	SPY	ETF	426.29	426.31	426.04	426.17	1101190.0
2021-06-25 13:30:00	SPY	ETF	426.17	426.32	425.9511	426.25	1832572.0
2021-06-25 14:00:00	SPY	ETF	426.26	426.44	426.14	426.38	1816143.0
2021-06-25 14:30:00	SPY	ETF	426.39	426.62	426.31	426.54	2366886.0
2021-06-25 15:00:00	SPY	ETF	426.55	426.96	426.51	426.59	3083238.0
2021-06-25 15:30:00	SPY	ETF	426.595	427.0943	426.41	426.56	14047705.0
2021-06-25 16:00:00	SPY	ETF	426.56	426.85	426.42	426.6	3621590.0
2021-06-25 16:30:00	SPY	ETF	426.6	426.9	426.58	426.86	161919.0
2021-06-25 17:00:00	SPY	ETF	426.71	426.86	426.55	426.67	49057.0
2021-06-25 17:30:00	SPY	ETF	426.65	426.99	426.65	426.87	17089.0
2021-06-25 18:00:00	SPY	ETF	426.86	426.99	426.86	426.92	14693.0
2021-06-25 18:30:00	SPY	ETF	426.98	426.99	426.7	426.85	18304.0
2021-06-25 19:00:00	SPY	ETF	426.76	426.82	426.69	426.77	23874.0
2021-06-25 19:30:00	SPY	ETF	426.73	426.89	426.73	426.88	10284.0
2021-06-25 04:00:00	QQQ	ETF	350.01	350.3	349.92	350.14	12477.0
2021-06-25 04:30:00	QQQ	ETF	350.26	350.3	350.17	350.25	7096.0
2021-06-25 05:00:00	QQQ	ETF	350.27	350.33	350.13	350.18	11029.0
2021-06-25 05:30:00	QQQ	ETF	350.16	350.7	350.14	350.58	31411.0
2021-06-25 06:00:00	QQQ	ETF	350.54	350.58	350.27	350.34	17466.0
2021-06-25 06:30:00	QQQ	ETF	350.37	350.57	350.36	350.57	9327.0
2021-06-25 07:00:00	QQQ	ETF	350.51	350.54	350.27	350.36	17523.0
2021-06-25 07:30:00	QQQ	ETF	350.43	350.43	350.0	350.07	43739.0
2021-06-25 08:00:00	QQQ	ETF	350.2899	350.52	349.85	349.85	79105.0
2021-06-25 08:30:00	QQQ	ETF	349.98	350.84	349.98	350.38	343169.0
2021-06-25 09:00:00	QQQ	ETF	350.4	350.58	350.33	350.4304	287922.0
2021-06-25 09:30:00	QQQ	ETF	350.47	350.72	349.24	349.53	3344225.0
2021-06-25 10:00:00	QQQ	ETF	349.53	350.2509	348.84	350.16	2752380.0
2021-06-25 10:30:00	QQQ	ETF	350.17	350.29	349.4	349.57	2008400.0
2021-06-25 11:00:00	QQQ	ETF	349.58	349.975	349.32	349.84	1317380.0
2021-06-25 11:30:00	QQQ	ETF	349.84	350.105	349.72	349.8795	976271.0
2021-06-25 12:00:00	QQQ	ETF	349.86	349.89	349.05	349.13	895694.0
2021-06-25 12:30:00	QQQ	ETF	349.15	349.56	349.0501	349.45	678938.0

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

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