PREVIEW / etf_30min / 2020-09-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-10.parquet
  size:    566 KB
  rows:    20,983

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-10 04:00:00	SPY	ETF	338.36	338.4	337.6	338.17	48762.0
2020-09-10 04:30:00	SPY	ETF	338.32	338.75	338.2	338.52	17429.0
2020-09-10 05:00:00	SPY	ETF	338.29	339.1	338.11	338.7	12752.0
2020-09-10 05:30:00	SPY	ETF	338.86	339.4	338.86	339.35	23578.0
2020-09-10 06:00:00	SPY	ETF	339.3	340.05	338.86	338.94	47822.0
2020-09-10 06:30:00	SPY	ETF	339.03	339.03	337.94	338.12	82136.0
2020-09-10 07:00:00	SPY	ETF	338.01	338.81	337.95	338.61	176590.0
2020-09-10 07:30:00	SPY	ETF	338.47	339.44	338.26	339.3	147518.0
2020-09-10 08:00:00	SPY	ETF	338.1799	340.92	338.02	339.61	415169.0
2020-09-10 08:30:00	SPY	ETF	339.64	341.18	339.21	340.78	257383.0
2020-09-10 09:00:00	SPY	ETF	340.87	341.84	340.72	341.79	336511.0
2020-09-10 09:30:00	SPY	ETF	341.82	342.43	341.2048	341.61	5146616.0
2020-09-10 10:00:00	SPY	ETF	341.62	342.53	341.2999	341.2999	4626577.0
2020-09-10 10:30:00	SPY	ETF	341.3	342.22	338.64	338.8	7265902.0
2020-09-10 11:00:00	SPY	ETF	338.8	340.82	338.12	340.81	6667964.0
2020-09-10 11:30:00	SPY	ETF	340.79	340.829	339.16	339.425	5704056.0
2020-09-10 12:00:00	SPY	ETF	339.43	339.9516	338.31	338.84	2907254.0
2020-09-10 12:30:00	SPY	ETF	338.82	339.16	337.33	338.5084	3740677.0
2020-09-10 13:00:00	SPY	ETF	338.4959	339.6	338.2183	338.521	2597535.0
2020-09-10 13:30:00	SPY	ETF	338.57	339.2	337.57	337.78	2492986.0
2020-09-10 14:00:00	SPY	ETF	337.75	338.51	334.18	334.28	6651518.0
2020-09-10 14:30:00	SPY	ETF	334.26	336.235	334.11	336.0217	8156845.0
2020-09-10 15:00:00	SPY	ETF	336.03	336.11	332.85	334.015	9006921.0
2020-09-10 15:30:00	SPY	ETF	334.04	335.65	333.56	333.92	16350929.0
2020-09-10 16:00:00	SPY	ETF	333.94	334.6	333.54	333.9	4943521.0
2020-09-10 16:30:00	SPY	ETF	333.95	334.81	333.95	334.33	586294.0
2020-09-10 17:00:00	SPY	ETF	334.3	334.37	333.89	334.1	162260.0
2020-09-10 17:30:00	SPY	ETF	334.1	334.5	334.09	334.49	83349.0
2020-09-10 18:00:00	SPY	ETF	334.44	335.25	334.44	334.89	77224.0
2020-09-10 18:30:00	SPY	ETF	334.95	335.28	334.92	334.95	25170.0
2020-09-10 19:00:00	SPY	ETF	335.04	335.31	334.8	335.21	24089.0
2020-09-10 19:30:00	SPY	ETF	335.25	335.3899	334.4	334.82	133829.0
2020-09-10 04:00:00	QQQ	ETF	275.7	276.02	274.84	275.69	59678.0
2020-09-10 04:30:00	QQQ	ETF	275.88	276.68	275.79	276.11	25684.0
2020-09-10 05:00:00	QQQ	ETF	276.07	276.95	275.99	276.76	11459.0
2020-09-10 05:30:00	QQQ	ETF	277.0	277.8	277.0	277.71	13221.0
2020-09-10 06:00:00	QQQ	ETF	277.72	278.56	277.24	277.5	37369.0
2020-09-10 06:30:00	QQQ	ETF	277.57	277.57	276.23	276.55	80043.0
2020-09-10 07:00:00	QQQ	ETF	276.54	277.59	276.54	277.44	113036.0
2020-09-10 07:30:00	QQQ	ETF	277.3	278.62	277.25	278.37	202549.0
2020-09-10 08:00:00	QQQ	ETF	276.7999	279.57	276.07	279.27	468157.0
2020-09-10 08:30:00	QQQ	ETF	279.4	280.54	278.77	280.31	382756.0
2020-09-10 09:00:00	QQQ	ETF	280.37	281.1	280.29	280.98	562944.0
2020-09-10 09:30:00	QQQ	ETF	280.97	281.7	279.52	280.69	5897655.0
2020-09-10 10:00:00	QQQ	ETF	280.68	282.195	280.62	280.985	3729886.0
2020-09-10 10:30:00	QQQ	ETF	280.96	281.98	277.64	277.9401	4389540.0
2020-09-10 11:00:00	QQQ	ETF	277.99	280.13	277.01	280.12	4201194.0
2020-09-10 11:30:00	QQQ	ETF	280.1	280.52	278.67	278.97	2141649.0
2020-09-10 12:00:00	QQQ	ETF	279.0	279.48	277.35	277.93	2482736.0
2020-09-10 12:30:00	QQQ	ETF	277.92	278.42	276.3	277.68	3397191.0

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

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