PREVIEW / etf_30min / 2020-09-08

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-08.parquet
  size:    587 KB
  rows:    22,076

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-08 04:00:00	SPY	ETF	343.44	343.58	341.11	341.57	31540.0
2020-09-08 04:30:00	SPY	ETF	341.6	341.63	340.27	340.44	39028.0
2020-09-08 05:00:00	SPY	ETF	340.33	341.14	340.2	340.6	31476.0
2020-09-08 05:30:00	SPY	ETF	340.58	340.65	339.58	339.78	79489.0
2020-09-08 06:00:00	SPY	ETF	339.68	340.16	338.92	338.92	147855.0
2020-09-08 06:30:00	SPY	ETF	339.03	339.47	338.72	339.47	203365.0
2020-09-08 07:00:00	SPY	ETF	339.55	340.2	338.8	339.43	171598.0
2020-09-08 07:30:00	SPY	ETF	339.4	339.43	337.42	338.34	288224.0
2020-09-08 08:00:00	SPY	ETF	339.7101	344.49	336.65	337.3	480836.0
2020-09-08 08:30:00	SPY	ETF	337.26	337.83	336.42	337.36	372758.0
2020-09-08 09:00:00	SPY	ETF	337.33	337.54	336.31	336.65	503868.0
2020-09-08 09:30:00	SPY	ETF	336.71	336.98	333.86	336.7	13906037.0
2020-09-08 10:00:00	SPY	ETF	336.72	337.62	334.8	337.4516	8714820.0
2020-09-08 10:30:00	SPY	ETF	337.45	338.06	335.12	335.85	6082488.0
2020-09-08 11:00:00	SPY	ETF	335.9	337.3599	335.3272	336.43	4930255.0
2020-09-08 11:30:00	SPY	ETF	336.41	336.64	334.43	335.49	4930165.0
2020-09-08 12:00:00	SPY	ETF	335.475	336.65	335.29	335.83	4971935.0
2020-09-08 12:30:00	SPY	ETF	335.8	336.99	335.5	336.77	3368847.0
2020-09-08 13:00:00	SPY	ETF	336.75	337.28	336.02	336.89	3441867.0
2020-09-08 13:30:00	SPY	ETF	336.88	337.74	336.47	337.1701	3841776.0
2020-09-08 14:00:00	SPY	ETF	337.2	342.64	335.2925	335.43	4851425.0
2020-09-08 14:30:00	SPY	ETF	335.42	335.42	333.03	334.5	7989147.0
2020-09-08 15:00:00	SPY	ETF	334.49	335.04	332.88	335.0	9732903.0
2020-09-08 15:30:00	SPY	ETF	335.0	335.51	332.88	333.26	21480869.0
2020-09-08 16:00:00	SPY	ETF	333.26	342.64	333.14	333.71	7720680.0
2020-09-08 16:30:00	SPY	ETF	333.7	334.05	333.39	333.69	752277.0
2020-09-08 17:00:00	SPY	ETF	333.58	333.7	331.3	331.85	468738.0
2020-09-08 17:30:00	SPY	ETF	331.96	333.21	329.65	330.89	729510.0
2020-09-08 18:00:00	SPY	ETF	330.89	332.19	329.75	331.4	751359.0
2020-09-08 18:30:00	SPY	ETF	331.35	331.89	330.99	331.7	351877.0
2020-09-08 19:00:00	SPY	ETF	331.82	332.3	331.21	331.83	100527.0
2020-09-08 19:30:00	SPY	ETF	332.0	332.57	331.52	332.3	85863.0
2020-09-08 04:00:00	QQQ	ETF	281.06	281.17	277.74	278.45	55387.0
2020-09-08 04:30:00	QQQ	ETF	278.48	278.79	276.69	277.23	98300.0
2020-09-08 05:00:00	QQQ	ETF	277.13	277.92	276.4	276.98	63573.0
2020-09-08 05:30:00	QQQ	ETF	277.05	277.09	274.9	275.29	140549.0
2020-09-08 06:00:00	QQQ	ETF	275.13	275.71	274.35	274.49	285774.0
2020-09-08 06:30:00	QQQ	ETF	274.73	276.2	274.73	276.2	309093.0
2020-09-08 07:00:00	QQQ	ETF	276.35	276.87	274.63	274.93	473140.0
2020-09-08 07:30:00	QQQ	ETF	274.96	275.19	273.4	273.78	527590.0
2020-09-08 08:00:00	QQQ	ETF	273.79	282.05	272.06	272.61	812009.0
2020-09-08 08:30:00	QQQ	ETF	272.65	275.0	272.38	273.76	1000833.0
2020-09-08 09:00:00	QQQ	ETF	273.61	273.95	272.2	272.24	778694.0
2020-09-08 09:30:00	QQQ	ETF	272.24	275.71	271.25	275.55	11241237.0
2020-09-08 10:00:00	QQQ	ETF	275.55	277.95	274.21	277.46	7079970.0
2020-09-08 10:30:00	QQQ	ETF	277.47	278.22	274.51	275.57	5314544.0
2020-09-08 11:00:00	QQQ	ETF	275.61	276.684	274.58	275.27	3272563.0
2020-09-08 11:30:00	QQQ	ETF	275.27	275.6	272.88	274.26	3947726.0
2020-09-08 12:00:00	QQQ	ETF	274.25	274.93	273.7	273.83	2546857.0
2020-09-08 12:30:00	QQQ	ETF	273.8	275.34	273.5701	275.13	2197236.0

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

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