PREVIEW / etf_30min / 2020-10-07

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-07.parquet
  size:    556 KB
  rows:    20,531

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-07 04:00:00	SPY	ETF	337.35	337.45	336.85	336.85	42430.0
2020-10-07 04:30:00	SPY	ETF	336.85	337.33	336.84	337.33	14930.0
2020-10-07 05:00:00	SPY	ETF	337.28	337.28	336.95	337.05	7601.0
2020-10-07 05:30:00	SPY	ETF	337.0	337.33	336.85	336.9	14935.0
2020-10-07 06:00:00	SPY	ETF	336.7	337.1	336.59	336.92	22270.0
2020-10-07 06:30:00	SPY	ETF	336.92	337.51	336.69	337.46	141126.0
2020-10-07 07:00:00	SPY	ETF	337.41	337.58	337.16	337.33	180902.0
2020-10-07 07:30:00	SPY	ETF	337.33	337.87	337.17	337.8	177271.0
2020-10-07 08:00:00	SPY	ETF	337.8	338.23	335.1	337.88	238697.0
2020-10-07 08:30:00	SPY	ETF	337.87	338.45	337.83	337.99	869865.0
2020-10-07 09:00:00	SPY	ETF	337.95	338.14	337.67	338.12	491922.0
2020-10-07 09:30:00	SPY	ETF	338.12	339.51	338.09	339.0	5295304.0
2020-10-07 10:00:00	SPY	ETF	339.0	339.5	338.37	339.31	3011106.0
2020-10-07 10:30:00	SPY	ETF	339.34	339.76	339.02	339.4765	2270049.0
2020-10-07 11:00:00	SPY	ETF	339.48	339.88	339.15	339.49	2462067.0
2020-10-07 11:30:00	SPY	ETF	339.5	339.74	339.34	339.39	1136760.0
2020-10-07 12:00:00	SPY	ETF	339.4	339.64	338.51	339.0433	2477720.0
2020-10-07 12:30:00	SPY	ETF	339.03	339.625	339.02	339.58	1502182.0
2020-10-07 13:00:00	SPY	ETF	339.57	339.87	339.5621	339.78	1974947.0
2020-10-07 13:30:00	SPY	ETF	339.78	340.8367	339.76	340.38	4233468.0
2020-10-07 14:00:00	SPY	ETF	340.38	341.31	340.24	341.21	3253919.0
2020-10-07 14:30:00	SPY	ETF	341.2	341.39	340.6903	341.24	2963568.0
2020-10-07 15:00:00	SPY	ETF	341.25	341.63	341.13	341.305	3941339.0
2020-10-07 15:30:00	SPY	ETF	341.31	341.4801	340.69	340.73	7987610.0
2020-10-07 16:00:00	SPY	ETF	340.73	340.917	340.37	340.78	9753686.0
2020-10-07 16:30:00	SPY	ETF	340.77	340.9	340.62	340.76	312276.0
2020-10-07 17:00:00	SPY	ETF	340.75	340.84	340.69	340.82	36454.0
2020-10-07 17:30:00	SPY	ETF	340.82	340.9	340.72	340.81	24192.0
2020-10-07 18:00:00	SPY	ETF	340.81	341.19	340.64	341.06	63566.0
2020-10-07 18:30:00	SPY	ETF	341.06	341.35	341.0	341.1	52688.0
2020-10-07 19:00:00	SPY	ETF	341.1	341.13	340.95	341.03	20743.0
2020-10-07 19:30:00	SPY	ETF	340.92	341.54	340.92	341.42	56729.0
2020-10-07 04:00:00	QQQ	ETF	276.9	277.0	276.55	276.56	40012.0
2020-10-07 04:30:00	QQQ	ETF	276.54	276.74	276.31	276.5	35491.0
2020-10-07 05:00:00	QQQ	ETF	276.49	276.71	276.35	276.65	25391.0
2020-10-07 05:30:00	QQQ	ETF	276.76	276.85	276.17	276.17	45883.0
2020-10-07 06:00:00	QQQ	ETF	276.13	276.39	276.04	276.23	16850.0
2020-10-07 06:30:00	QQQ	ETF	276.23	276.65	275.94	276.54	45706.0
2020-10-07 07:00:00	QQQ	ETF	276.54	276.8	276.42	276.66	119507.0
2020-10-07 07:30:00	QQQ	ETF	276.64	277.26	276.52	277.2	107997.0
2020-10-07 08:00:00	QQQ	ETF	276.51	277.65	275.28	277.33	160145.0
2020-10-07 08:30:00	QQQ	ETF	277.2602	277.88	277.25	277.57	169367.0
2020-10-07 09:00:00	QQQ	ETF	277.6	278.03	277.43	277.84	207885.0
2020-10-07 09:30:00	QQQ	ETF	277.83	279.088	277.81	278.42	3089553.0
2020-10-07 10:00:00	QQQ	ETF	278.42	278.56	277.43	277.61	2367039.0
2020-10-07 10:30:00	QQQ	ETF	277.6	278.67	277.28	278.5366	1842394.0
2020-10-07 11:00:00	QQQ	ETF	278.525	279.015	278.42	278.83	1456670.0
2020-10-07 11:30:00	QQQ	ETF	278.84	279.22	278.75	278.85	919423.0
2020-10-07 12:00:00	QQQ	ETF	278.86	279.43	278.01	278.5542	1289306.0
2020-10-07 12:30:00	QQQ	ETF	278.57	279.59	278.54	279.53	1019514.0

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

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