PREVIEW / etf_30min / 2020-10-27

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-27.parquet
  size:    554 KB
  rows:    20,297

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-10-27 04:00:00	SPY	ETF	340.42	340.42	339.25	339.58	62126.0
2020-10-27 04:30:00	SPY	ETF	339.57	340.19	339.54	340.03	35481.0
2020-10-27 05:00:00	SPY	ETF	339.89	339.91	339.34	339.86	19992.0
2020-10-27 05:30:00	SPY	ETF	340.0	340.0	339.7	339.87	7788.0
2020-10-27 06:00:00	SPY	ETF	340.06	340.26	340.04	340.22	9864.0
2020-10-27 06:30:00	SPY	ETF	340.29	341.05	340.28	340.82	82005.0
2020-10-27 07:00:00	SPY	ETF	340.79	341.0	340.56	340.88	180981.0
2020-10-27 07:30:00	SPY	ETF	340.86	341.01	340.77	341.01	85926.0
2020-10-27 08:00:00	SPY	ETF	341.0	341.01	340.15	340.57	301128.0
2020-10-27 08:30:00	SPY	ETF	340.56	340.67	339.84	339.9	238904.0
2020-10-27 09:00:00	SPY	ETF	339.88	340.16	339.6	339.73	123053.0
2020-10-27 09:30:00	SPY	ETF	339.76	340.05	338.77	339.69	5252982.0
2020-10-27 10:00:00	SPY	ETF	339.7	340.08	338.14	338.47	4720863.0
2020-10-27 10:30:00	SPY	ETF	338.47	339.7	338.33	338.78	3541805.0
2020-10-27 11:00:00	SPY	ETF	338.78	339.6	338.56	338.66	2733914.0
2020-10-27 11:30:00	SPY	ETF	338.66	339.84	338.1922	339.76	3386607.0
2020-10-27 12:00:00	SPY	ETF	339.77	340.04	339.21	339.24	2285088.0
2020-10-27 12:30:00	SPY	ETF	339.24	339.2738	338.53	339.01	2748522.0
2020-10-27 13:00:00	SPY	ETF	339.01	339.6	338.563	339.53	2663517.0
2020-10-27 13:30:00	SPY	ETF	339.54	340.12	339.47	339.66	2371949.0
2020-10-27 14:00:00	SPY	ETF	339.65	339.8182	338.72	339.093	2444201.0
2020-10-27 14:30:00	SPY	ETF	339.1	339.21	338.27	338.56	2850718.0
2020-10-27 15:00:00	SPY	ETF	338.56	339.2738	337.99	338.905	4655837.0
2020-10-27 15:30:00	SPY	ETF	338.9	339.33	338.16	338.25	11829004.0
2020-10-27 16:00:00	SPY	ETF	338.28	338.62	337.6	337.86	10418161.0
2020-10-27 16:30:00	SPY	ETF	337.87	337.89	336.9	336.91	731922.0
2020-10-27 17:00:00	SPY	ETF	336.86	339.2738	336.21	336.35	428942.0
2020-10-27 17:30:00	SPY	ETF	336.48	337.0	336.44	336.85	168215.0
2020-10-27 18:00:00	SPY	ETF	336.84	336.89	335.77	335.86	284620.0
2020-10-27 18:30:00	SPY	ETF	335.91	336.16	335.86	335.96	67400.0
2020-10-27 19:00:00	SPY	ETF	335.98	336.37	335.98	336.3	85272.0
2020-10-27 19:30:00	SPY	ETF	336.3	336.64	336.3	336.55	57977.0
2020-10-27 04:00:00	QQQ	ETF	281.47	281.47	280.64	280.84	47744.0
2020-10-27 04:30:00	QQQ	ETF	280.93	281.3	280.83	281.26	31551.0
2020-10-27 05:00:00	QQQ	ETF	281.23	281.3	280.77	281.17	26175.0
2020-10-27 05:30:00	QQQ	ETF	281.16	281.48	281.04	281.21	24662.0
2020-10-27 06:00:00	QQQ	ETF	281.23	281.55	281.21	281.42	12096.0
2020-10-27 06:30:00	QQQ	ETF	281.45	282.1	281.38	281.68	71496.0
2020-10-27 07:00:00	QQQ	ETF	281.72	281.98	281.59	281.69	48904.0
2020-10-27 07:30:00	QQQ	ETF	281.7	282.06	281.64	282.06	75587.0
2020-10-27 08:00:00	QQQ	ETF	282.05	282.13	280.85	281.63	89503.0
2020-10-27 08:30:00	QQQ	ETF	281.66	281.73	281.4	281.42	107249.0
2020-10-27 09:00:00	QQQ	ETF	281.4	281.77	281.21	281.38	181272.0
2020-10-27 09:30:00	QQQ	ETF	281.41	282.42	280.5	281.77	3404887.0
2020-10-27 10:00:00	QQQ	ETF	281.79	281.98	280.2	280.57	2053161.0
2020-10-27 10:30:00	QQQ	ETF	280.57	282.35	280.41	281.83	1588003.0
2020-10-27 11:00:00	QQQ	ETF	281.83	282.7401	281.58	281.95	1958971.0
2020-10-27 11:30:00	QQQ	ETF	281.955	283.11	281.45	282.99	1311645.0
2020-10-27 12:00:00	QQQ	ETF	283.0	283.16	282.01	282.02	1244423.0
2020-10-27 12:30:00	QQQ	ETF	282.06	282.41	281.7	282.3228	1176199.0

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

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