PREVIEW / etf_30min / 2021-02-02

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-02.parquet
  size:    627 KB
  rows:    24,014

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-02-02 04:00:00	SPY	ETF	378.89	379.51	378.83	379.48	201064.0
2021-02-02 04:30:00	SPY	ETF	379.33	379.8	379.3	379.53	78386.0
2021-02-02 05:00:00	SPY	ETF	379.54	379.78	379.29	379.37	23168.0
2021-02-02 05:30:00	SPY	ETF	379.34	380.0	379.34	379.73	50428.0
2021-02-02 06:00:00	SPY	ETF	379.73	379.87	379.41	379.43	10859.0
2021-02-02 06:30:00	SPY	ETF	379.49	379.49	378.97	378.97	31747.0
2021-02-02 07:00:00	SPY	ETF	378.97	379.53	378.92	379.41	81172.0
2021-02-02 07:30:00	SPY	ETF	379.33	379.53	379.1	379.15	132936.0
2021-02-02 08:00:00	SPY	ETF	379.0899	379.55	378.25	379.26	213577.0
2021-02-02 08:30:00	SPY	ETF	379.25	379.72	379.11	379.62	243522.0
2021-02-02 09:00:00	SPY	ETF	379.62	379.66	379.22	379.59	207946.0
2021-02-02 09:30:00	SPY	ETF	379.61	381.21	379.6	380.87	6056569.0
2021-02-02 10:00:00	SPY	ETF	380.89	382.54	380.87	381.5102	5315594.0
2021-02-02 10:30:00	SPY	ETF	381.52	382.2	381.44	382.08	2657542.0
2021-02-02 11:00:00	SPY	ETF	382.07	382.96	381.93	382.57	2704620.0
2021-02-02 11:30:00	SPY	ETF	382.575	383.1	382.38	383.03	1991250.0
2021-02-02 12:00:00	SPY	ETF	383.03	383.22	382.51	382.5911	1741443.0
2021-02-02 12:30:00	SPY	ETF	382.6	382.9889	382.51	382.9889	1373878.0
2021-02-02 13:00:00	SPY	ETF	382.99	383.08	382.21	382.4301	1543832.0
2021-02-02 13:30:00	SPY	ETF	382.44	382.93	382.42	382.63	1435120.0
2021-02-02 14:00:00	SPY	ETF	382.63	382.8892	382.46	382.565	1749011.0
2021-02-02 14:30:00	SPY	ETF	382.57	383.14	382.54	383.12	1943915.0
2021-02-02 15:00:00	SPY	ETF	383.11	383.12	382.39	382.7481	2566136.0
2021-02-02 15:30:00	SPY	ETF	382.74	382.78	381.38	381.54	11778064.0
2021-02-02 16:00:00	SPY	ETF	381.54	382.44	381.07	382.22	4341591.0
2021-02-02 16:30:00	SPY	ETF	382.17	382.5	381.55	382.43	282801.0
2021-02-02 17:00:00	SPY	ETF	382.48	382.73	382.48	382.6	51651.0
2021-02-02 17:30:00	SPY	ETF	382.6	382.72	382.5	382.54	78264.0
2021-02-02 18:00:00	SPY	ETF	382.65	382.84	382.17	382.77	88110.0
2021-02-02 18:30:00	SPY	ETF	381.55	382.97	381.55	382.47	89234.0
2021-02-02 19:00:00	SPY	ETF	382.5	382.88	382.24	382.88	197544.0
2021-02-02 19:30:00	SPY	ETF	382.88	383.5	382.71	383.34	234507.0
2021-02-02 04:00:00	QQQ	ETF	324.97	325.56	324.86	325.44	21128.0
2021-02-02 04:30:00	QQQ	ETF	325.31	326.0	325.27	325.75	13062.0
2021-02-02 05:00:00	QQQ	ETF	325.73	325.88	325.49	325.52	14189.0
2021-02-02 05:30:00	QQQ	ETF	325.54	325.84	325.49	325.7	16113.0
2021-02-02 06:00:00	QQQ	ETF	325.68	325.7	325.21	325.21	23021.0
2021-02-02 06:30:00	QQQ	ETF	325.33	325.4	324.98	324.99	26775.0
2021-02-02 07:00:00	QQQ	ETF	324.92	325.49	324.83	325.37	57774.0
2021-02-02 07:30:00	QQQ	ETF	325.27	325.34	325.0	325.11	121820.0
2021-02-02 08:00:00	QQQ	ETF	325.1	325.69	322.42	325.17	161705.0
2021-02-02 08:30:00	QQQ	ETF	325.21	325.62	325.129	325.48	168741.0
2021-02-02 09:00:00	QQQ	ETF	325.45	325.56	324.94	325.51	293963.0
2021-02-02 09:30:00	QQQ	ETF	325.47	327.21	325.31	326.175	3698860.0
2021-02-02 10:00:00	QQQ	ETF	326.18	327.52	325.855	326.24	2842651.0
2021-02-02 10:30:00	QQQ	ETF	326.2101	327.225	326.2101	327.0	1576526.0
2021-02-02 11:00:00	QQQ	ETF	326.99	327.47	326.53	327.32	1245481.0
2021-02-02 11:30:00	QQQ	ETF	327.31	328.03	326.78	327.99	1070772.0
2021-02-02 12:00:00	QQQ	ETF	327.99	328.32	327.83	328.082	971356.0
2021-02-02 12:30:00	QQQ	ETF	328.09	328.28	327.8	328.08	662078.0

> showing 50 of 24,014 rows — these rows as CSV

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