PREVIEW / etf_30min / 2020-09-18

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-18.parquet
  size:    543 KB
  rows:    20,056

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-09-18 04:00:00	SPY	ETF	334.51	335.16	334.33	335.0	122056.0
2020-09-18 04:30:00	SPY	ETF	334.86	334.86	334.59	334.79	7061.0
2020-09-18 05:00:00	SPY	ETF	334.76	335.23	334.64	335.22	13796.0
2020-09-18 05:30:00	SPY	ETF	335.27	335.51	334.8	334.87	18758.0
2020-09-18 06:00:00	SPY	ETF	334.85	335.03	334.72	335.0	17426.0
2020-09-18 06:30:00	SPY	ETF	335.01	335.18	334.73	335.01	6789.0
2020-09-18 07:00:00	SPY	ETF	335.05	335.43	334.94	335.42	40479.0
2020-09-18 07:30:00	SPY	ETF	335.41	335.73	334.94	335.09	87121.0
2020-09-18 08:00:00	SPY	ETF	335.34	335.5801	334.36	335.07	125574.0
2020-09-18 08:30:00	SPY	ETF	335.1	335.82	335.05	335.82	136868.0
2020-09-18 09:00:00	SPY	ETF	335.79	336.15	335.25	335.36	488251.0
2020-09-18 09:30:00	SPY	ETF	335.37	335.49	333.05	333.91	9820723.0
2020-09-18 10:00:00	SPY	ETF	333.915	334.99	333.885	334.46	4689308.0
2020-09-18 10:30:00	SPY	ETF	334.4615	334.54	332.54	332.78	8830600.0
2020-09-18 11:00:00	SPY	ETF	332.77	333.3	332.24	332.805	7237004.0
2020-09-18 11:30:00	SPY	ETF	332.81	333.36	331.86	333.0	5917783.0
2020-09-18 12:00:00	SPY	ETF	333.0	333.34	331.71	332.15	5950946.0
2020-09-18 12:30:00	SPY	ETF	332.17	332.18	330.57	330.905	6376133.0
2020-09-18 13:00:00	SPY	ETF	330.89	331.115	329.08	329.09	7207171.0
2020-09-18 13:30:00	SPY	ETF	329.09	329.98	327.97	329.96	8075714.0
2020-09-18 14:00:00	SPY	ETF	329.96	330.29	329.091	330.041	4993432.0
2020-09-18 14:30:00	SPY	ETF	330.04	330.5401	329.62	330.53	3472145.0
2020-09-18 15:00:00	SPY	ETF	330.53	331.27	330.33	331.225	4581432.0
2020-09-18 15:30:00	SPY	ETF	331.22	331.57	330.55	330.69	11991884.0
2020-09-18 16:00:00	SPY	ETF	330.68	334.1127	330.44	331.43	9802319.0
2020-09-18 16:30:00	SPY	ETF	331.44	331.57	330.65	331.49	2533120.0
2020-09-18 17:00:00	SPY	ETF	331.46	331.5	331.1	331.11	124568.0
2020-09-18 17:30:00	SPY	ETF	331.11	331.44	330.65	331.4	1581844.0
2020-09-18 18:00:00	SPY	ETF	331.35	331.43	331.27	331.41	14515.0
2020-09-18 18:30:00	SPY	ETF	331.4	331.43	331.01	331.17	39434.0
2020-09-18 19:00:00	SPY	ETF	331.29	331.48	331.2	331.2	25976.0
2020-09-18 19:30:00	SPY	ETF	331.35	331.4	331.11	331.26	17482.0
2020-09-18 04:00:00	QQQ	ETF	270.95	271.67	270.63	271.47	31339.0
2020-09-18 04:30:00	QQQ	ETF	271.53	271.54	270.97	271.25	16858.0
2020-09-18 05:00:00	QQQ	ETF	271.25	271.9	271.19	271.89	16905.0
2020-09-18 05:30:00	QQQ	ETF	271.91	272.2	271.4	271.5	22508.0
2020-09-18 06:00:00	QQQ	ETF	271.4	271.78	271.28	271.73	17926.0
2020-09-18 06:30:00	QQQ	ETF	271.7	271.9	271.33	271.46	11110.0
2020-09-18 07:00:00	QQQ	ETF	271.43	272.2	271.38	272.18	118973.0
2020-09-18 07:30:00	QQQ	ETF	272.25	272.5	271.7	271.93	115909.0
2020-09-18 08:00:00	QQQ	ETF	271.88	272.4	270.31	271.72	339651.0
2020-09-18 08:30:00	QQQ	ETF	271.69	272.12	271.6602	272.07	113414.0
2020-09-18 09:00:00	QQQ	ETF	272.1002	272.66	271.5	271.63	683160.0
2020-09-18 09:30:00	QQQ	ETF	271.62	272.09	269.23	270.18	5750556.0
2020-09-18 10:00:00	QQQ	ETF	270.2	271.35	269.53	269.899	2890255.0
2020-09-18 10:30:00	QQQ	ETF	269.91	269.984	267.47	267.8	4866360.0
2020-09-18 11:00:00	QQQ	ETF	267.8	268.23	266.94	267.59	4832306.0
2020-09-18 11:30:00	QQQ	ETF	267.61	268.07	266.21	267.68	4089072.0
2020-09-18 12:00:00	QQQ	ETF	267.62	268.22	266.12	266.4975	3398545.0
2020-09-18 12:30:00	QQQ	ETF	266.48	266.58	264.51	265.18	4821490.0

> showing 50 of 20,056 rows — these rows as CSV

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