PREVIEW / etf_30min / 2020-09-15

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-15.parquet
  size:    550 KB
  rows:    20,315

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-15 04:00:00	SPY	ETF	339.24	339.63	339.24	339.53	4053.0
2020-09-15 04:30:00	SPY	ETF	339.51	340.0	339.51	339.9	2753.0
2020-09-15 05:00:00	SPY	ETF	340.0	340.55	339.99	340.55	16191.0
2020-09-15 05:30:00	SPY	ETF	340.58	340.78	340.45	340.78	3834.0
2020-09-15 06:00:00	SPY	ETF	340.55	340.65	340.4	340.41	14960.0
2020-09-15 06:30:00	SPY	ETF	340.34	340.92	340.32	340.84	84715.0
2020-09-15 07:00:00	SPY	ETF	340.84	340.89	340.6	340.71	98938.0
2020-09-15 07:30:00	SPY	ETF	340.69	341.01	340.67	340.71	77470.0
2020-09-15 08:00:00	SPY	ETF	340.7501	341.0	339.05	340.81	183665.0
2020-09-15 08:30:00	SPY	ETF	340.81	341.69	340.81	341.28	414234.0
2020-09-15 09:00:00	SPY	ETF	341.29	341.46	341.06	341.09	339679.0
2020-09-15 09:30:00	SPY	ETF	341.12	342.02	341.06	341.605	4732341.0
2020-09-15 10:00:00	SPY	ETF	341.61	341.98	340.8	341.35	3332254.0
2020-09-15 10:30:00	SPY	ETF	341.36	341.81	340.6	341.515	3152799.0
2020-09-15 11:00:00	SPY	ETF	341.515	341.9	341.24	341.58	2869019.0
2020-09-15 11:30:00	SPY	ETF	341.57	341.87	341.08	341.31	2835270.0
2020-09-15 12:00:00	SPY	ETF	341.3081	341.68	341.26	341.58	1592619.0
2020-09-15 12:30:00	SPY	ETF	341.555	341.75	341.5	341.685	2804268.0
2020-09-15 13:00:00	SPY	ETF	341.68	341.95	341.42	341.5	2265269.0
2020-09-15 13:30:00	SPY	ETF	341.5	341.64	341.12	341.17	1553025.0
2020-09-15 14:00:00	SPY	ETF	341.16	341.23	340.43	340.81	2509989.0
2020-09-15 14:30:00	SPY	ETF	340.83	341.01	340.44	340.85	2387996.0
2020-09-15 15:00:00	SPY	ETF	340.87	340.89	339.6	339.98	5459927.0
2020-09-15 15:30:00	SPY	ETF	339.98	340.4	339.02	340.15	9497293.0
2020-09-15 16:00:00	SPY	ETF	340.14	340.8	340.11	340.68	4186260.0
2020-09-15 16:30:00	SPY	ETF	340.66	340.84	340.17	340.66	658758.0
2020-09-15 17:00:00	SPY	ETF	340.6	340.78	340.17	340.77	66125.0
2020-09-15 17:30:00	SPY	ETF	340.78	340.8	340.67	340.76	32063.0
2020-09-15 18:00:00	SPY	ETF	340.74	340.99	340.68	340.74	53385.0
2020-09-15 18:30:00	SPY	ETF	340.76	340.7899	340.55	340.7899	20420.0
2020-09-15 19:00:00	SPY	ETF	340.78	340.78	340.15	340.33	39513.0
2020-09-15 19:30:00	SPY	ETF	340.32	340.38	339.94	340.28	82967.0
2020-09-15 04:00:00	QQQ	ETF	276.44	276.84	276.44	276.71	11970.0
2020-09-15 04:30:00	QQQ	ETF	276.68	276.97	276.57	276.84	10841.0
2020-09-15 05:00:00	QQQ	ETF	277.03	277.72	277.03	277.72	14607.0
2020-09-15 05:30:00	QQQ	ETF	277.71	278.1	277.7	277.84	35758.0
2020-09-15 06:00:00	QQQ	ETF	277.84	277.84	277.38	277.55	24497.0
2020-09-15 06:30:00	QQQ	ETF	277.44	277.87	277.33	277.77	26127.0
2020-09-15 07:00:00	QQQ	ETF	277.79	278.05	277.65	278.05	91940.0
2020-09-15 07:30:00	QQQ	ETF	277.99	278.44	277.99	278.09	132119.0
2020-09-15 08:00:00	QQQ	ETF	278.06	278.44	275.8	278.27	93543.0
2020-09-15 08:30:00	QQQ	ETF	278.34	278.78	278.25	278.49	191796.0
2020-09-15 09:00:00	QQQ	ETF	278.49	279.02	278.48	278.91	293026.0
2020-09-15 09:30:00	QQQ	ETF	278.9	280.14	278.49	280.14	4354260.0
2020-09-15 10:00:00	QQQ	ETF	280.135	280.24	278.35	278.99	3503509.0
2020-09-15 10:30:00	QQQ	ETF	279.0	279.36	277.6859	278.92	2871025.0
2020-09-15 11:00:00	QQQ	ETF	278.91	279.67	278.72	279.42	1920497.0
2020-09-15 11:30:00	QQQ	ETF	279.41	279.91	279.06	279.52	1282157.0
2020-09-15 12:00:00	QQQ	ETF	279.52	280.1	279.495	279.89	1239288.0
2020-09-15 12:30:00	QQQ	ETF	279.88	280.32	279.6428	280.19	1002583.0

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

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