PREVIEW / etf_30min / 2020-08-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-13.parquet
  size:    549 KB
  rows:    20,195

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-08-13 04:00:00	SPY	ETF	336.98	337.13	336.6	336.64	50560.0
2020-08-13 04:30:00	SPY	ETF	336.6	337.09	336.53	337.09	4059.0
2020-08-13 05:00:00	SPY	ETF	337.03	337.03	336.96	336.98	752.0
2020-08-13 05:30:00	SPY	ETF	336.71	336.75	336.61	336.75	3209.0
2020-08-13 06:00:00	SPY	ETF	336.72	336.79	336.72	336.75	4137.0
2020-08-13 06:30:00	SPY	ETF	336.87	336.93	336.79	336.79	6344.0
2020-08-13 07:00:00	SPY	ETF	336.67	336.93	336.64	336.7	39579.0
2020-08-13 07:30:00	SPY	ETF	336.7	336.75	336.54	336.66	58744.0
2020-08-13 08:00:00	SPY	ETF	336.61	336.92	336.52	336.7	104209.0
2020-08-13 08:30:00	SPY	ETF	336.75	337.48	336.75	337.2	317392.0
2020-08-13 09:00:00	SPY	ETF	337.2	337.21	336.58	336.58	235033.0
2020-08-13 09:30:00	SPY	ETF	336.61	337.93	336.46	337.91	4665201.0
2020-08-13 10:00:00	SPY	ETF	337.9	337.98	337.28	337.66	2187073.0
2020-08-13 10:30:00	SPY	ETF	337.67	337.96	337.5	337.82	2020408.0
2020-08-13 11:00:00	SPY	ETF	337.82	338.12	337.75	337.85	1646671.0
2020-08-13 11:30:00	SPY	ETF	337.85	337.87	337.49	337.68	2021847.0
2020-08-13 12:00:00	SPY	ETF	337.7	338.03	337.69	337.84	1122224.0
2020-08-13 12:30:00	SPY	ETF	337.84	338.15	337.82	338.11	1087222.0
2020-08-13 13:00:00	SPY	ETF	338.1	338.2514	337.44	337.585	2539357.0
2020-08-13 13:30:00	SPY	ETF	337.59	337.88	337.06	337.6	2528931.0
2020-08-13 14:00:00	SPY	ETF	337.605	337.72	336.23	336.875	3614939.0
2020-08-13 14:30:00	SPY	ETF	336.875	337.095	335.83	336.25	4208794.0
2020-08-13 15:00:00	SPY	ETF	336.26	337.21	335.96	337.16	3046062.0
2020-08-13 15:30:00	SPY	ETF	337.17	337.35	336.54	336.86	6293668.0
2020-08-13 16:00:00	SPY	ETF	336.84	336.9126	336.47	336.89	2987077.0
2020-08-13 16:30:00	SPY	ETF	336.85	337.14	336.83	337.06	275969.0
2020-08-13 17:00:00	SPY	ETF	337.06	337.06	336.86	336.86	37338.0
2020-08-13 17:30:00	SPY	ETF	336.9	336.98	336.84	336.98	27031.0
2020-08-13 18:00:00	SPY	ETF	336.97	337.2	336.97	337.08	47549.0
2020-08-13 18:30:00	SPY	ETF	337.09	337.35	337.09	337.33	49369.0
2020-08-13 19:00:00	SPY	ETF	337.35	337.6399	337.35	337.54	46223.0
2020-08-13 19:30:00	SPY	ETF	337.53	337.74	337.52	337.62	23682.0
2020-08-13 04:00:00	QQQ	ETF	271.59	271.59	270.73	270.95	6898.0
2020-08-13 04:30:00	QQQ	ETF	270.92	271.41	270.92	271.34	1506.0
2020-08-13 05:00:00	QQQ	ETF	271.25	271.45	271.09	271.19	2761.0
2020-08-13 05:30:00	QQQ	ETF	271.23	271.29	271.01	271.12	3648.0
2020-08-13 06:00:00	QQQ	ETF	271.1	271.32	271.1	271.32	3576.0
2020-08-13 06:30:00	QQQ	ETF	271.17	271.38	271.17	271.19	5538.0
2020-08-13 07:00:00	QQQ	ETF	271.25	271.72	271.23	271.61	36657.0
2020-08-13 07:30:00	QQQ	ETF	271.57	271.95	271.46	271.84	48232.0
2020-08-13 08:00:00	QQQ	ETF	271.7301	272.42	270.77	272.2	380289.0
2020-08-13 08:30:00	QQQ	ETF	272.2	273.21	272.2	273.06	316210.0
2020-08-13 09:00:00	QQQ	ETF	273.05	273.14	272.5	272.59	175427.0
2020-08-13 09:30:00	QQQ	ETF	272.62	273.96	272.39	273.62	4402040.0
2020-08-13 10:00:00	QQQ	ETF	273.61	273.94	272.68	273.85	2178700.0
2020-08-13 10:30:00	QQQ	ETF	273.87	274.44	273.8024	274.17	1912166.0
2020-08-13 11:00:00	QQQ	ETF	274.17	274.68	274.1	274.19	1312376.0
2020-08-13 11:30:00	QQQ	ETF	274.195	274.26	273.6437	274.049	1063099.0
2020-08-13 12:00:00	QQQ	ETF	274.04	274.49	274.0	274.35	746233.0
2020-08-13 12:30:00	QQQ	ETF	274.34	274.7	274.33	274.6712	685948.0

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

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