PREVIEW / etf_30min / 2020-09-17

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-17.parquet
  size:    553 KB
  rows:    20,465

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-17 04:00:00	SPY	ETF	334.42	335.44	334.42	335.44	92580.0
2020-09-17 04:30:00	SPY	ETF	335.52	335.59	334.94	335.3	29273.0
2020-09-17 05:00:00	SPY	ETF	335.42	335.6	335.0	335.24	22859.0
2020-09-17 05:30:00	SPY	ETF	335.2	335.8	335.2	335.79	29541.0
2020-09-17 06:00:00	SPY	ETF	335.65	335.7	335.25	335.53	46421.0
2020-09-17 06:30:00	SPY	ETF	335.6	335.86	334.74	334.8	44947.0
2020-09-17 07:00:00	SPY	ETF	334.84	335.64	334.58	335.2	203247.0
2020-09-17 07:30:00	SPY	ETF	335.24	335.43	334.6	334.64	181182.0
2020-09-17 08:00:00	SPY	ETF	334.8301	336.64	333.5	334.55	343384.0
2020-09-17 08:30:00	SPY	ETF	334.4	334.5	333.18	333.3701	783475.0
2020-09-17 09:00:00	SPY	ETF	333.37	333.78	332.77	333.54	691821.0
2020-09-17 09:30:00	SPY	ETF	333.56	335.36	333.17	335.16	11292509.0
2020-09-17 10:00:00	SPY	ETF	335.165	336.81	334.84	335.73	8571163.0
2020-09-17 10:30:00	SPY	ETF	335.745	337.25	335.08	336.32	7045294.0
2020-09-17 11:00:00	SPY	ETF	336.33	337.6996	336.33	336.71	4460424.0
2020-09-17 11:30:00	SPY	ETF	336.68	337.07	334.91	335.19	6157521.0
2020-09-17 12:00:00	SPY	ETF	335.16	335.46	332.991	333.764	5862038.0
2020-09-17 12:30:00	SPY	ETF	333.74	334.52	333.12	334.515	6472254.0
2020-09-17 13:00:00	SPY	ETF	334.51	334.66	333.57	334.08	4247538.0
2020-09-17 13:30:00	SPY	ETF	334.09	334.95	333.93	334.38	4161053.0
2020-09-17 14:00:00	SPY	ETF	334.415	335.31	333.9	333.91	3017070.0
2020-09-17 14:30:00	SPY	ETF	333.9042	334.5	333.32	334.02	3371876.0
2020-09-17 15:00:00	SPY	ETF	334.03	334.6599	333.0	333.66	6109590.0
2020-09-17 15:30:00	SPY	ETF	333.65	336.04	333.515	335.86	11142671.0
2020-09-17 16:00:00	SPY	ETF	335.87	338.6783	335.79	336.17	4887555.0
2020-09-17 16:30:00	SPY	ETF	336.19	336.4	335.8	335.91	804827.0
2020-09-17 17:00:00	SPY	ETF	335.91	335.93	335.7	335.8413	199271.0
2020-09-17 17:30:00	SPY	ETF	335.73	335.85	335.6	335.75	32345.0
2020-09-17 18:00:00	SPY	ETF	335.73	336.2	335.73	336.19	85611.0
2020-09-17 18:30:00	SPY	ETF	336.19	336.68	336.19	336.65	38755.0
2020-09-17 19:00:00	SPY	ETF	336.67	336.95	336.67	336.81	53511.0
2020-09-17 19:30:00	SPY	ETF	336.81	336.84	335.99	336.02	91462.0
2020-09-17 04:00:00	QQQ	ETF	270.45	271.45	270.42	271.4	91937.0
2020-09-17 04:30:00	QQQ	ETF	271.55	271.61	270.94	271.48	68118.0
2020-09-17 05:00:00	QQQ	ETF	271.6	272.17	271.22	271.7	27354.0
2020-09-17 05:30:00	QQQ	ETF	271.74	272.91	271.74	272.68	51079.0
2020-09-17 06:00:00	QQQ	ETF	272.68	272.7	271.86	272.22	51509.0
2020-09-17 06:30:00	QQQ	ETF	272.45	272.53	270.5	270.51	158503.0
2020-09-17 07:00:00	QQQ	ETF	270.52	271.3	270.2	270.41	279885.0
2020-09-17 07:30:00	QQQ	ETF	270.39	270.8	269.34	269.62	323259.0
2020-09-17 08:00:00	QQQ	ETF	269.62	272.23	268.75	269.27	582358.0
2020-09-17 08:30:00	QQQ	ETF	269.49	269.49	268.0	268.17	610976.0
2020-09-17 09:00:00	QQQ	ETF	268.21	268.23	266.44	267.5	1879269.0
2020-09-17 09:30:00	QQQ	ETF	267.5	270.41	267.38	270.28	9976009.0
2020-09-17 10:00:00	QQQ	ETF	270.28	271.41	268.89	269.63	5649208.0
2020-09-17 10:30:00	QQQ	ETF	269.61	271.88	268.98	270.78	3164498.0
2020-09-17 11:00:00	QQQ	ETF	270.79	272.37	270.63	271.18	2642413.0
2020-09-17 11:30:00	QQQ	ETF	271.16	271.7	268.74	268.89	3942777.0
2020-09-17 12:00:00	QQQ	ETF	268.87	269.48	267.11	267.87	4612494.0
2020-09-17 12:30:00	QQQ	ETF	267.88	268.4	266.68	268.39	4321459.0

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

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