PREVIEW / etf_30min / 2022-03-15

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-15.parquet
  size:    676 KB
  rows:    27,108

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
2022-03-15 04:00:00	SPY	ETF	415.71	417.48	414.89	415.15	36122.0
2022-03-15 04:30:00	SPY	ETF	415.07	415.45	414.0	414.25	23199.0
2022-03-15 05:00:00	SPY	ETF	414.21	415.16	413.61	415.0	22051.0
2022-03-15 05:30:00	SPY	ETF	414.99	416.23	414.87	415.37	68300.0
2022-03-15 06:00:00	SPY	ETF	415.36	416.42	415.36	416.3	69369.0
2022-03-15 06:30:00	SPY	ETF	416.44	417.97	416.4	417.42	99687.0
2022-03-15 07:00:00	SPY	ETF	417.32	418.45	417.32	417.41	144685.0
2022-03-15 07:30:00	SPY	ETF	417.48	417.96	416.9	417.42	303723.0
2022-03-15 08:00:00	SPY	ETF	418.2201	418.5	414.8004	418.03	293701.0
2022-03-15 08:30:00	SPY	ETF	417.85	420.05	417.85	419.26	530942.0
2022-03-15 09:00:00	SPY	ETF	419.27	420.15	419.06	419.76	391494.0
2022-03-15 09:30:00	SPY	ETF	419.77	421.33	418.42	420.37	8267672.0
2022-03-15 10:00:00	SPY	ETF	420.37	421.8	419.12	421.7401	6157304.0
2022-03-15 10:30:00	SPY	ETF	421.72	422.83	421.47	421.77	5043559.0
2022-03-15 11:00:00	SPY	ETF	421.76	423.21	421.71	423.16	3604440.0
2022-03-15 11:30:00	SPY	ETF	423.16	424.25	421.83	422.53	6378057.0
2022-03-15 12:00:00	SPY	ETF	422.5366	424.3	421.56	424.08	3801170.0
2022-03-15 12:30:00	SPY	ETF	424.07	424.41	422.52	423.58	2969579.0
2022-03-15 13:00:00	SPY	ETF	423.57	424.13	422.095	422.11	2363188.0
2022-03-15 13:30:00	SPY	ETF	422.1	423.39	421.84	423.2	1991403.0
2022-03-15 14:00:00	SPY	ETF	423.2	423.47	421.37	422.08	3645538.0
2022-03-15 14:30:00	SPY	ETF	422.08	424.78	421.65	424.62	3376896.0
2022-03-15 15:00:00	SPY	ETF	424.64	426.05	424.38	425.772	5775277.0
2022-03-15 15:30:00	SPY	ETF	425.785	426.84	425.34	426.14	16456895.0
2022-03-15 16:00:00	SPY	ETF	426.15	426.2	423.7334	425.51	5006294.0
2022-03-15 16:30:00	SPY	ETF	425.475	426.17	425.38	425.55	274433.0
2022-03-15 17:00:00	SPY	ETF	425.47	426.17	425.3	425.58	89290.0
2022-03-15 17:30:00	SPY	ETF	425.63	425.63	425.52	425.52	26962.0
2022-03-15 18:00:00	SPY	ETF	425.55	425.6	425.1	425.32	48330.0
2022-03-15 18:30:00	SPY	ETF	425.38	425.42	425.22	425.23	50449.0
2022-03-15 19:00:00	SPY	ETF	425.3	425.55	425.11	425.32	58403.0
2022-03-15 19:30:00	SPY	ETF	425.29	426.29	425.17	425.4	89345.0
2022-03-15 04:00:00	QQQ	ETF	318.0	319.05	316.73	317.11	90978.0
2022-03-15 04:30:00	QQQ	ETF	317.04	317.28	316.24	316.27	38146.0
2022-03-15 05:00:00	QQQ	ETF	316.41	317.4	315.71	317.1	70623.0
2022-03-15 05:30:00	QQQ	ETF	317.11	317.99	316.78	317.13	76956.0
2022-03-15 06:00:00	QQQ	ETF	317.1	318.18	317.1	318.04	76583.0
2022-03-15 06:30:00	QQQ	ETF	318.09	319.4	318.02	318.98	193885.0
2022-03-15 07:00:00	QQQ	ETF	318.88	320.04	318.88	319.27	159702.0
2022-03-15 07:30:00	QQQ	ETF	319.36	319.75	318.49	319.03	246883.0
2022-03-15 08:00:00	QQQ	ETF	319.39	320.15	315.8804	319.56	279269.0
2022-03-15 08:30:00	QQQ	ETF	319.51	321.55	319.33	320.65	1001775.0
2022-03-15 09:00:00	QQQ	ETF	320.66	321.5	320.23	320.97	728198.0
2022-03-15 09:30:00	QQQ	ETF	320.88	322.17	319.23	321.49	8143510.0
2022-03-15 10:00:00	QQQ	ETF	321.5296	323.48	321.0	323.45	5627567.0
2022-03-15 10:30:00	QQQ	ETF	323.47	324.8891	323.34	324.13	3816391.0
2022-03-15 11:00:00	QQQ	ETF	324.13	325.78	323.98	325.74	3205304.0
2022-03-15 11:30:00	QQQ	ETF	325.73	326.93	324.19	324.895	5226974.0
2022-03-15 12:00:00	QQQ	ETF	324.86	326.45	323.96	326.22	4646196.0
2022-03-15 12:30:00	QQQ	ETF	326.23	326.44	324.47	325.5099	2773783.0

> showing 50 of 27,108 rows — these rows as CSV

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