PREVIEW / etf_30min / 2021-06-04

all etf 30-min files

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

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-04 04:00:00	SPY	ETF	418.91	419.22	418.82	418.82	2795.0
2021-06-04 04:30:00	SPY	ETF	418.79	418.79	418.64	418.78	600.0
2021-06-04 05:00:00	SPY	ETF	418.7	418.95	418.67	418.79	4365.0
2021-06-04 05:30:00	SPY	ETF	418.72	419.03	418.64	419.03	3116.0
2021-06-04 06:00:00	SPY	ETF	418.8	418.87	418.57	418.66	2511.0
2021-06-04 06:30:00	SPY	ETF	418.66	418.8	418.46	418.77	84116.0
2021-06-04 07:00:00	SPY	ETF	418.84	419.31	418.84	419.25	36081.0
2021-06-04 07:30:00	SPY	ETF	419.28	419.3	418.99	419.2	35492.0
2021-06-04 08:00:00	SPY	ETF	419.2599	419.61	418.7304	419.23	133217.0
2021-06-04 08:30:00	SPY	ETF	419.27	420.76	418.74	420.44	994480.0
2021-06-04 09:00:00	SPY	ETF	420.56	420.83	420.42	420.79	161870.0
2021-06-04 09:30:00	SPY	ETF	420.75	421.5	420.68	421.25	4972800.0
2021-06-04 10:00:00	SPY	ETF	421.25	421.645	421.23	421.365	3559113.0
2021-06-04 10:30:00	SPY	ETF	421.365	421.87	421.32	421.715	2508816.0
2021-06-04 11:00:00	SPY	ETF	421.72	422.02	421.68	421.87	2012545.0
2021-06-04 11:30:00	SPY	ETF	421.87	421.91	421.46	421.585	1347526.0
2021-06-04 12:00:00	SPY	ETF	421.5899	421.74	421.47	421.61	1002921.0
2021-06-04 12:30:00	SPY	ETF	421.62	421.895	421.62	421.88	871366.0
2021-06-04 13:00:00	SPY	ETF	421.88	422.02	421.77	421.82	944196.0
2021-06-04 13:30:00	SPY	ETF	421.82	422.21	421.82	422.155	1378498.0
2021-06-04 14:00:00	SPY	ETF	422.155	422.419	422.15	422.419	1905254.0
2021-06-04 14:30:00	SPY	ETF	422.415	422.65	422.4	422.4901	2180655.0
2021-06-04 15:00:00	SPY	ETF	422.495	422.54	422.34	422.48	2074406.0
2021-06-04 15:30:00	SPY	ETF	422.47	422.92	422.36	422.57	9609457.0
2021-06-04 16:00:00	SPY	ETF	422.57	422.6	422.21	422.34	4018891.0
2021-06-04 16:30:00	SPY	ETF	422.34	422.6	422.34	422.47	186163.0
2021-06-04 17:00:00	SPY	ETF	422.48	422.69	422.41	422.6	509212.0
2021-06-04 17:30:00	SPY	ETF	422.6	422.65	422.5	422.52	23303.0
2021-06-04 18:00:00	SPY	ETF	422.52	422.54	422.5	422.5	14140.0
2021-06-04 18:30:00	SPY	ETF	422.6	422.6	422.5	422.56	9371.0
2021-06-04 19:00:00	SPY	ETF	422.56	422.68	422.56	422.6	1873.0
2021-06-04 19:30:00	SPY	ETF	422.61	422.68	422.58	422.62	3154.0
2021-06-04 04:00:00	QQQ	ETF	329.79	330.29	329.79	329.91	41107.0
2021-06-04 04:30:00	QQQ	ETF	329.95	329.95	329.72	329.82	5100.0
2021-06-04 05:00:00	QQQ	ETF	329.9	330.05	329.81	329.82	8017.0
2021-06-04 05:30:00	QQQ	ETF	329.75	330.19	329.71	330.16	24017.0
2021-06-04 06:00:00	QQQ	ETF	330.05	330.06	329.82	329.96	7979.0
2021-06-04 06:30:00	QQQ	ETF	329.71	330.09	329.23	330.0	29884.0
2021-06-04 07:00:00	QQQ	ETF	330.07	330.54	330.07	330.47	69682.0
2021-06-04 07:30:00	QQQ	ETF	330.43	330.49	330.14	330.47	40610.0
2021-06-04 08:00:00	QQQ	ETF	330.29	330.83	329.5404	330.45	104688.0
2021-06-04 08:30:00	QQQ	ETF	330.43	331.83	329.88	331.56	1384360.0
2021-06-04 09:00:00	QQQ	ETF	331.6	332.05	331.43	331.85	231856.0
2021-06-04 09:30:00	QQQ	ETF	331.85	334.1401	331.78	333.9999	5090060.0
2021-06-04 10:00:00	QQQ	ETF	334.01	335.25	334.01	334.63	4358812.0
2021-06-04 10:30:00	QQQ	ETF	334.64	335.41	334.55	334.88	2204256.0
2021-06-04 11:00:00	QQQ	ETF	334.89	335.72	334.7799	335.6	1678711.0
2021-06-04 11:30:00	QQQ	ETF	335.6	335.615	335.26	335.3618	996894.0
2021-06-04 12:00:00	QQQ	ETF	335.38	335.55	335.15	335.39	860183.0
2021-06-04 12:30:00	QQQ	ETF	335.395	335.65	335.3	335.48	767049.0

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

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