PREVIEW / etf_30min / 2021-04-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-23.parquet
  size:    605 KB
  rows:    22,654

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-23 04:00:00	SPY	ETF	412.68	413.57	412.68	413.24	7237.0
2021-04-23 04:30:00	SPY	ETF	413.32	413.57	413.32	413.45	10042.0
2021-04-23 05:00:00	SPY	ETF	413.34	413.34	413.11	413.15	11507.0
2021-04-23 05:30:00	SPY	ETF	413.28	413.38	413.08	413.22	9857.0
2021-04-23 06:00:00	SPY	ETF	413.23	413.46	413.2	413.3	6200.0
2021-04-23 06:30:00	SPY	ETF	413.38	413.51	413.23	413.3	19422.0
2021-04-23 07:00:00	SPY	ETF	413.39	413.5	413.15	413.26	42501.0
2021-04-23 07:30:00	SPY	ETF	413.27	413.3	413.0	413.08	47211.0
2021-04-23 08:00:00	SPY	ETF	413.38	413.5	412.59	412.74	129563.0
2021-04-23 08:30:00	SPY	ETF	412.71	412.84	412.53	412.72	118431.0
2021-04-23 09:00:00	SPY	ETF	412.72	413.04	412.68	412.85	182166.0
2021-04-23 09:30:00	SPY	ETF	412.87	414.2	412.79	414.18	5145975.0
2021-04-23 10:00:00	SPY	ETF	414.19	414.47	414.11	414.3488	3236645.0
2021-04-23 10:30:00	SPY	ETF	414.345	416.02	414.233	415.9601	4632571.0
2021-04-23 11:00:00	SPY	ETF	415.97	416.34	415.6119	416.15	3793019.0
2021-04-23 11:30:00	SPY	ETF	416.155	416.475	416.015	416.2505	2387071.0
2021-04-23 12:00:00	SPY	ETF	416.25	416.55	416.25	416.415	1473484.0
2021-04-23 12:30:00	SPY	ETF	416.42	417.28	416.4	417.102	2961202.0
2021-04-23 13:00:00	SPY	ETF	417.1	417.18	416.9	417.045	1739366.0
2021-04-23 13:30:00	SPY	ETF	417.05	417.38	416.99	417.02	1808456.0
2021-04-23 14:00:00	SPY	ETF	417.015	417.26	416.75	417.015	2295425.0
2021-04-23 14:30:00	SPY	ETF	417.015	417.58	416.93	417.375	2545603.0
2021-04-23 15:00:00	SPY	ETF	417.371	417.86	417.21	417.785	3672741.0
2021-04-23 15:30:00	SPY	ETF	417.78	418.25	416.64	416.72	12100818.0
2021-04-23 16:00:00	SPY	ETF	416.71	416.84	416.26	416.37	4686868.0
2021-04-23 16:30:00	SPY	ETF	416.33	416.74	416.17	416.25	250578.0
2021-04-23 17:00:00	SPY	ETF	416.27	416.33	416.18	416.18	47808.0
2021-04-23 17:30:00	SPY	ETF	416.22	416.74	416.14	416.36	37700.0
2021-04-23 18:00:00	SPY	ETF	416.35	416.44	416.34	416.42	23438.0
2021-04-23 18:30:00	SPY	ETF	416.43	416.43	416.15	416.33	6833.0
2021-04-23 19:00:00	SPY	ETF	416.3	416.3	416.14	416.2	34346.0
2021-04-23 19:30:00	SPY	ETF	416.2	416.28	416.17	416.25	11306.0
2021-04-23 04:00:00	QQQ	ETF	336.01	336.03	335.74	335.81	28799.0
2021-04-23 04:30:00	QQQ	ETF	335.84	336.02	335.81	335.82	17156.0
2021-04-23 05:00:00	QQQ	ETF	335.77	335.88	335.64	335.88	5840.0
2021-04-23 05:30:00	QQQ	ETF	335.85	335.86	335.68	335.7	8153.0
2021-04-23 06:00:00	QQQ	ETF	335.72	336.04	335.69	335.93	22394.0
2021-04-23 06:30:00	QQQ	ETF	335.98	336.05	335.8	335.88	35698.0
2021-04-23 07:00:00	QQQ	ETF	335.86	335.98	335.55	335.79	80715.0
2021-04-23 07:30:00	QQQ	ETF	335.8	335.87	335.57	335.82	78786.0
2021-04-23 08:00:00	QQQ	ETF	335.86	336.01	335.03	335.73	151730.0
2021-04-23 08:30:00	QQQ	ETF	335.76	335.82	335.56	335.71	76918.0
2021-04-23 09:00:00	QQQ	ETF	335.79	335.9	335.58	335.83	70480.0
2021-04-23 09:30:00	QQQ	ETF	335.85	337.25	335.84	337.1	3200108.0
2021-04-23 10:00:00	QQQ	ETF	337.13	337.69	336.91	337.2	1918493.0
2021-04-23 10:30:00	QQQ	ETF	337.215	338.195	337.01	338.1312	2408137.0
2021-04-23 11:00:00	QQQ	ETF	338.1396	339.23	337.91	339.03	2074259.0
2021-04-23 11:30:00	QQQ	ETF	339.03	339.7	339.02	339.39	2119742.0
2021-04-23 12:00:00	QQQ	ETF	339.4	339.73	339.3001	339.36	1281960.0
2021-04-23 12:30:00	QQQ	ETF	339.36	340.18	339.3255	340.04	1669481.0

> showing 50 of 22,654 rows — these rows as CSV

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