PREVIEW / etf_30min / 2021-02-18

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-18.parquet
  size:    635 KB
  rows:    23,807

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-02-18 04:00:00	SPY	ETF	392.16	392.16	391.46	391.6	5940.0
2021-02-18 04:30:00	SPY	ETF	391.26	391.59	391.09	391.5	4450.0
2021-02-18 05:00:00	SPY	ETF	391.54	391.58	391.18	391.22	4647.0
2021-02-18 05:30:00	SPY	ETF	391.2	391.35	390.94	391.02	9102.0
2021-02-18 06:00:00	SPY	ETF	391.02	391.02	390.18	390.8	127027.0
2021-02-18 06:30:00	SPY	ETF	390.74	391.01	390.66	390.95	12390.0
2021-02-18 07:00:00	SPY	ETF	391.04	391.1	390.87	391.03	103350.0
2021-02-18 07:30:00	SPY	ETF	391.12	391.32	391.04	391.05	170285.0
2021-02-18 08:00:00	SPY	ETF	391.0601	391.87	390.42	390.69	399018.0
2021-02-18 08:30:00	SPY	ETF	390.69	390.8	389.58	389.85	579432.0
2021-02-18 09:00:00	SPY	ETF	389.85	389.87	389.04	389.57	393301.0
2021-02-18 09:30:00	SPY	ETF	389.57	390.29	388.89	389.83	5693911.0
2021-02-18 10:00:00	SPY	ETF	389.82	389.87	387.88	388.5042	5809558.0
2021-02-18 10:30:00	SPY	ETF	388.49	389.47	387.74	388.992	4125299.0
2021-02-18 11:00:00	SPY	ETF	388.985	389.86	388.72	389.1913	2862101.0
2021-02-18 11:30:00	SPY	ETF	389.18	389.38	388.68	388.93	1571840.0
2021-02-18 12:00:00	SPY	ETF	388.93	389.24	388.2	389.225	2081115.0
2021-02-18 12:30:00	SPY	ETF	389.22	389.43	388.9	389.165	1156964.0
2021-02-18 13:00:00	SPY	ETF	389.1619	390.43	388.82	390.235	2687703.0
2021-02-18 13:30:00	SPY	ETF	390.24	390.54	390.15	390.255	1715065.0
2021-02-18 14:00:00	SPY	ETF	390.259	390.96	390.23	390.73	3060083.0
2021-02-18 14:30:00	SPY	ETF	390.715	391.13	390.48	391.05	2570996.0
2021-02-18 15:00:00	SPY	ETF	391.04	391.43	390.8714	391.16	2467769.0
2021-02-18 15:30:00	SPY	ETF	391.16	391.515	390.39	390.75	6673907.0
2021-02-18 16:00:00	SPY	ETF	390.76	391.04	390.51	390.65	2923971.0
2021-02-18 16:30:00	SPY	ETF	390.64	390.82	390.56	390.7	146670.0
2021-02-18 17:00:00	SPY	ETF	390.57	390.71	390.57	390.69	36346.0
2021-02-18 17:30:00	SPY	ETF	390.7	390.77	390.61	390.74	20711.0
2021-02-18 18:00:00	SPY	ETF	390.74	391.03	390.6	390.92	67004.0
2021-02-18 18:30:00	SPY	ETF	390.72	390.98	390.04	390.2	92429.0
2021-02-18 19:00:00	SPY	ETF	390.22	390.45	390.14	390.28	19554.0
2021-02-18 19:30:00	SPY	ETF	390.31	390.4999	390.27	390.45	16425.0
2021-02-18 04:00:00	QQQ	ETF	332.7	332.75	332.15	332.19	13102.0
2021-02-18 04:30:00	QQQ	ETF	332.04	332.38	331.94	332.28	22139.0
2021-02-18 05:00:00	QQQ	ETF	332.23	332.31	331.79	331.85	12897.0
2021-02-18 05:30:00	QQQ	ETF	331.97	331.98	331.64	331.73	19916.0
2021-02-18 06:00:00	QQQ	ETF	331.6	331.66	330.82	331.28	55112.0
2021-02-18 06:30:00	QQQ	ETF	331.3	331.5	331.12	331.5	31964.0
2021-02-18 07:00:00	QQQ	ETF	331.5	331.74	331.4	331.74	58368.0
2021-02-18 07:30:00	QQQ	ETF	331.72	331.88	331.55	331.61	41645.0
2021-02-18 08:00:00	QQQ	ETF	331.3504	332.54	331.16	331.24	136038.0
2021-02-18 08:30:00	QQQ	ETF	331.28	331.4	330.41	330.63	361815.0
2021-02-18 09:00:00	QQQ	ETF	330.58	330.58	329.78	330.13	555914.0
2021-02-18 09:30:00	QQQ	ETF	330.19	331.13	329.69	330.78	3287164.0
2021-02-18 10:00:00	QQQ	ETF	330.74	330.8049	328.42	329.015	3724394.0
2021-02-18 10:30:00	QQQ	ETF	328.96	330.1682	328.36	329.81	1862491.0
2021-02-18 11:00:00	QQQ	ETF	329.81	330.851	329.48	330.2421	1741428.0
2021-02-18 11:30:00	QQQ	ETF	330.24	330.6	329.5501	329.9099	746542.0
2021-02-18 12:00:00	QQQ	ETF	329.905	330.63	329.04	330.62	1040395.0
2021-02-18 12:30:00	QQQ	ETF	330.6	330.76	330.15	330.51	676508.0

> showing 50 of 23,807 rows — these rows as CSV

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