PREVIEW / etf_30min / 2020-11-04

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-04.parquet
  size:    588 KB
  rows:    21,904

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-11-04 04:00:00	SPY	ETF	337.8	340.35	337.3	340.35	125413.0
2020-11-04 04:30:00	SPY	ETF	340.25	340.77	337.91	338.16	184898.0
2020-11-04 05:00:00	SPY	ETF	337.85	338.22	336.76	337.15	98259.0
2020-11-04 05:30:00	SPY	ETF	336.73	338.12	335.78	337.8	108465.0
2020-11-04 06:00:00	SPY	ETF	337.55	338.2	337.01	337.09	117333.0
2020-11-04 06:30:00	SPY	ETF	337.2	338.93	337.2	338.15	291534.0
2020-11-04 07:00:00	SPY	ETF	338.02	340.51	337.5	340.47	359717.0
2020-11-04 07:30:00	SPY	ETF	340.5	342.12	340.01	341.73	951253.0
2020-11-04 08:00:00	SPY	ETF	340.02	342.98	333.0	342.92	1424089.0
2020-11-04 08:30:00	SPY	ETF	342.9	342.91	341.13	341.47	963698.0
2020-11-04 09:00:00	SPY	ETF	341.4	341.87	338.9625	340.81	875627.0
2020-11-04 09:30:00	SPY	ETF	340.86	342.54	339.59	342.5	16669120.0
2020-11-04 10:00:00	SPY	ETF	342.49	346.475	342.33	345.11	12981500.0
2020-11-04 10:30:00	SPY	ETF	345.11	345.88	343.94	345.85	9326231.0
2020-11-04 11:00:00	SPY	ETF	345.84	346.08	344.36	345.63	5005188.0
2020-11-04 11:30:00	SPY	ETF	345.55	347.01	345.55	346.67	5097495.0
2020-11-04 12:00:00	SPY	ETF	346.67	347.94	346.3	347.32	5239175.0
2020-11-04 12:30:00	SPY	ETF	347.37	347.87	346.67	346.76	4737162.0
2020-11-04 13:00:00	SPY	ETF	346.77	347.0	345.96	346.29	3981698.0
2020-11-04 13:30:00	SPY	ETF	346.31	347.17	345.46	345.85	5850435.0
2020-11-04 14:00:00	SPY	ETF	345.88	346.49	345.45	345.91	6021846.0
2020-11-04 14:30:00	SPY	ETF	345.91	346.13	344.81	345.32	7367971.0
2020-11-04 15:00:00	SPY	ETF	345.32	345.69	343.71	343.78	8375302.0
2020-11-04 15:30:00	SPY	ETF	343.79	344.585	343.16	343.49	20492262.0
2020-11-04 16:00:00	SPY	ETF	343.48	344.02	343.18	343.86	7201125.0
2020-11-04 16:30:00	SPY	ETF	343.86	345.0	343.86	344.05	525959.0
2020-11-04 17:00:00	SPY	ETF	344.09	344.66	343.54	344.52	102532.0
2020-11-04 17:30:00	SPY	ETF	344.55	344.75	344.48	344.7	58176.0
2020-11-04 18:00:00	SPY	ETF	344.63	344.63	343.4	344.24	185679.0
2020-11-04 18:30:00	SPY	ETF	344.22	344.39	342.91	343.4	110603.0
2020-11-04 19:00:00	SPY	ETF	343.4	344.5	343.15	344.24	106079.0
2020-11-04 19:30:00	SPY	ETF	344.38	344.72	344.09	344.44	109989.0
2020-11-04 04:00:00	QQQ	ETF	281.53	283.05	280.9	283.04	181641.0
2020-11-04 04:30:00	QQQ	ETF	282.74	283.69	282.11	282.29	212320.0
2020-11-04 05:00:00	QQQ	ETF	282.19	282.3	280.57	280.72	187963.0
2020-11-04 05:30:00	QQQ	ETF	280.51	281.89	279.4	281.2	185751.0
2020-11-04 06:00:00	QQQ	ETF	281.1	281.52	279.57	279.57	123370.0
2020-11-04 06:30:00	QQQ	ETF	279.8	282.26	279.8	281.35	349494.0
2020-11-04 07:00:00	QQQ	ETF	281.27	282.75	280.49	282.65	1177156.0
2020-11-04 07:30:00	QQQ	ETF	282.65	284.21	282.0	284.1	1066138.0
2020-11-04 08:00:00	QQQ	ETF	284.1	286.09	276.21	285.83	1551395.0
2020-11-04 08:30:00	QQQ	ETF	285.75	285.75	284.29	284.47	979094.0
2020-11-04 09:00:00	QQQ	ETF	284.5	285.0	283.19	283.54	1268518.0
2020-11-04 09:30:00	QQQ	ETF	283.56	284.63	281.87	284.04	7853488.0
2020-11-04 10:00:00	QQQ	ETF	284.0	287.7149	283.74	286.9	7808742.0
2020-11-04 10:30:00	QQQ	ETF	286.91	287.44	285.7302	287.35	3975245.0
2020-11-04 11:00:00	QQQ	ETF	287.33	287.59	285.65	286.63	2451662.0
2020-11-04 11:30:00	QQQ	ETF	286.63	288.07	286.62	287.8	2772690.0
2020-11-04 12:00:00	QQQ	ETF	287.8	288.64	287.11	288.22	2551240.0
2020-11-04 12:30:00	QQQ	ETF	288.25	288.77	287.795	287.85	1977828.0

> showing 50 of 21,904 rows — these rows as CSV

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