PREVIEW / etf_30min / 2021-04-12

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-12.parquet
  size:    612 KB
  rows:    23,473

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
2021-04-12 04:00:00	SPY	ETF	410.66	410.68	410.35	410.35	11058.0
2021-04-12 04:30:00	SPY	ETF	410.37	410.55	410.36	410.54	900.0
2021-04-12 05:00:00	SPY	ETF	410.69	410.82	410.66	410.82	4306.0
2021-04-12 05:30:00	SPY	ETF	410.89	410.95	410.72	410.89	9571.0
2021-04-12 06:00:00	SPY	ETF	410.75	410.94	410.66	410.69	3705.0
2021-04-12 06:30:00	SPY	ETF	410.69	410.75	410.67	410.74	5300.0
2021-04-12 07:00:00	SPY	ETF	410.72	411.17	410.69	411.11	28132.0
2021-04-12 07:30:00	SPY	ETF	411.13	411.16	410.77	410.848	26161.0
2021-04-12 08:00:00	SPY	ETF	410.9	411.16	410.46	410.92	43139.0
2021-04-12 08:30:00	SPY	ETF	410.95	411.09	410.8999	410.96	65617.0
2021-04-12 09:00:00	SPY	ETF	410.99	411.25	410.82	410.85	155443.0
2021-04-12 09:30:00	SPY	ETF	410.84	411.49	410.45	410.88	4388041.0
2021-04-12 10:00:00	SPY	ETF	410.87	411.21	410.7198	410.8581	3401418.0
2021-04-12 10:30:00	SPY	ETF	410.8581	410.915	410.2	410.7439	3013621.0
2021-04-12 11:00:00	SPY	ETF	410.75	411.065	410.6	411.0219	2525629.0
2021-04-12 11:30:00	SPY	ETF	411.03	411.2	410.65	411.14	1866645.0
2021-04-12 12:00:00	SPY	ETF	411.15	411.343	410.81	411.31	1469755.0
2021-04-12 12:30:00	SPY	ETF	411.31	411.79	411.28	411.65	2267312.0
2021-04-12 13:00:00	SPY	ETF	411.65	411.74	411.15	411.2	1884281.0
2021-04-12 13:30:00	SPY	ETF	411.195	411.21	410.61	410.73	2615893.0
2021-04-12 14:00:00	SPY	ETF	410.74	411.13	410.69	411.12	2211159.0
2021-04-12 14:30:00	SPY	ETF	411.12	411.13	410.635	410.84	1759486.0
2021-04-12 15:00:00	SPY	ETF	410.84	411.17	410.52	411.023	2794539.0
2021-04-12 15:30:00	SPY	ETF	411.02	411.93	410.88	411.62	9816636.0
2021-04-12 16:00:00	SPY	ETF	411.62	412.0	411.2197	411.66	1691720.0
2021-04-12 16:30:00	SPY	ETF	411.69	411.83	411.62	411.78	208783.0
2021-04-12 17:00:00	SPY	ETF	411.77	411.77	411.67	411.7	24369.0
2021-04-12 17:30:00	SPY	ETF	411.68	411.77	411.65	411.77	23836.0
2021-04-12 18:00:00	SPY	ETF	411.77	411.82	411.6	411.6	41461.0
2021-04-12 18:30:00	SPY	ETF	411.6	411.67	411.6	411.62	4176.0
2021-04-12 19:00:00	SPY	ETF	411.59	411.62	411.47	411.5	18377.0
2021-04-12 19:30:00	SPY	ETF	411.6	411.87	411.6	411.67	27416.0
2021-04-12 04:00:00	QQQ	ETF	337.0	337.0	336.48	336.58	25737.0
2021-04-12 04:30:00	QQQ	ETF	336.56	336.65	336.4	336.4	8585.0
2021-04-12 05:00:00	QQQ	ETF	336.57	336.67	336.45	336.65	8349.0
2021-04-12 05:30:00	QQQ	ETF	336.55	336.87	336.55	336.76	11172.0
2021-04-12 06:00:00	QQQ	ETF	336.57	336.68	335.99	336.01	15440.0
2021-04-12 06:30:00	QQQ	ETF	336.01	336.08	335.83	335.88	46945.0
2021-04-12 07:00:00	QQQ	ETF	335.9	336.45	335.87	336.39	52001.0
2021-04-12 07:30:00	QQQ	ETF	336.4	336.44	336.0	336.12	75161.0
2021-04-12 08:00:00	QQQ	ETF	336.16	336.76	335.88	336.17	63330.0
2021-04-12 08:30:00	QQQ	ETF	336.19	336.44	336.16	336.28	53249.0
2021-04-12 09:00:00	QQQ	ETF	336.28	336.62	335.92	336.03	219288.0
2021-04-12 09:30:00	QQQ	ETF	336.04	336.63	335.0	335.6002	3287227.0
2021-04-12 10:00:00	QQQ	ETF	335.6	336.52	335.59	335.86	1864685.0
2021-04-12 10:30:00	QQQ	ETF	335.88	335.93	334.73	335.7109	2148955.0
2021-04-12 11:00:00	QQQ	ETF	335.72	336.2	335.68	336.001	1184584.0
2021-04-12 11:30:00	QQQ	ETF	336.01	336.0899	335.2818	335.95	1350944.0
2021-04-12 12:00:00	QQQ	ETF	335.9592	336.4	335.47	336.27	928730.0
2021-04-12 12:30:00	QQQ	ETF	336.27	336.84	336.26	336.79	1088113.0

> showing 50 of 23,473 rows — these rows as CSV

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