PREVIEW / etf_30min / 2021-08-10

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-10.parquet
  size:    601 KB
  rows:    22,806

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-08-10 04:00:00	SPY	ETF	442.15	442.3	442.0	442.08	9512.0
2021-08-10 04:30:00	SPY	ETF	442.11	442.11	442.0	442.11	1942.0
2021-08-10 05:00:00	SPY	ETF	442.15	442.15	442.08	442.08	2268.0
2021-08-10 05:30:00	SPY	ETF	442.09	442.16	442.09	442.1	2482.0
2021-08-10 06:00:00	SPY	ETF	442.09	442.11	442.0	442.11	2197.0
2021-08-10 06:30:00	SPY	ETF	442.1	442.19	442.06	442.16	10462.0
2021-08-10 07:00:00	SPY	ETF	442.05	442.26	442.05	442.18	13693.0
2021-08-10 07:30:00	SPY	ETF	442.25	442.28	442.14	442.19	29376.0
2021-08-10 08:00:00	SPY	ETF	442.2399	442.511	441.63	442.25	35604.0
2021-08-10 08:30:00	SPY	ETF	442.24	442.32	442.23	442.25	49989.0
2021-08-10 09:00:00	SPY	ETF	442.28	442.61	442.27	442.6	106136.0
2021-08-10 09:30:00	SPY	ETF	442.61	443.03	442.23	442.8924	3249639.0
2021-08-10 10:00:00	SPY	ETF	442.895	443.44	442.85	443.1	3678930.0
2021-08-10 10:30:00	SPY	ETF	443.1	443.12	441.88	442.33	5270079.0
2021-08-10 11:00:00	SPY	ETF	442.335	442.685	441.92	442.6001	2409539.0
2021-08-10 11:30:00	SPY	ETF	442.6	443.045	442.41	443.04	1623863.0
2021-08-10 12:00:00	SPY	ETF	443.03	443.31	442.92	443.04	1377837.0
2021-08-10 12:30:00	SPY	ETF	443.035	443.05	442.76	442.895	1024910.0
2021-08-10 13:00:00	SPY	ETF	442.895	443.0	442.73	442.855	944557.0
2021-08-10 13:30:00	SPY	ETF	442.855	443.0	442.5021	442.965	1294043.0
2021-08-10 14:00:00	SPY	ETF	442.96	443.07	442.4	442.795	2479044.0
2021-08-10 14:30:00	SPY	ETF	442.79	442.92	442.745	442.84	1112146.0
2021-08-10 15:00:00	SPY	ETF	442.85	442.89	442.5	442.69	1340857.0
2021-08-10 15:30:00	SPY	ETF	442.6881	442.72	442.21	442.66	5333105.0
2021-08-10 16:00:00	SPY	ETF	442.67	442.68	442.28	442.48	2867761.0
2021-08-10 16:30:00	SPY	ETF	442.5	442.64	442.49	442.57	91082.0
2021-08-10 17:00:00	SPY	ETF	442.5	442.57	442.44	442.56	6881.0
2021-08-10 17:30:00	SPY	ETF	442.56	442.59	442.46	442.53	22184.0
2021-08-10 18:00:00	SPY	ETF	442.53	442.59	442.43	442.52	31904.0
2021-08-10 18:30:00	SPY	ETF	442.48	442.52	442.36	442.4	20088.0
2021-08-10 19:00:00	SPY	ETF	442.39	442.43	442.31	442.35	9721.0
2021-08-10 19:30:00	SPY	ETF	442.38	442.48	442.31	442.4	14310.0
2021-08-10 04:00:00	QQQ	ETF	369.0	369.32	369.0	369.01	12661.0
2021-08-10 04:30:00	QQQ	ETF	368.94	369.0	368.84	369.0	9888.0
2021-08-10 05:00:00	QQQ	ETF	368.99	369.15	368.99	369.07	5424.0
2021-08-10 05:30:00	QQQ	ETF	369.16	369.3	369.16	369.3	6750.0
2021-08-10 06:00:00	QQQ	ETF	369.22	369.25	369.05	369.24	13427.0
2021-08-10 06:30:00	QQQ	ETF	369.22	369.24	369.13	369.17	9526.0
2021-08-10 07:00:00	QQQ	ETF	369.13	369.4	369.13	369.15	35500.0
2021-08-10 07:30:00	QQQ	ETF	369.13	369.26	369.1	369.26	35767.0
2021-08-10 08:00:00	QQQ	ETF	369.17	369.37	368.88	369.25	62311.0
2021-08-10 08:30:00	QQQ	ETF	369.25	369.36	369.07	369.07	43543.0
2021-08-10 09:00:00	QQQ	ETF	369.101	369.3	369.09	369.2696	34920.0
2021-08-10 09:30:00	QQQ	ETF	369.26	369.46	368.588	369.32	2695386.0
2021-08-10 10:00:00	QQQ	ETF	369.32	369.56	368.06	368.07	2663726.0
2021-08-10 10:30:00	QQQ	ETF	368.08	368.08	365.91	366.615	4643588.0
2021-08-10 11:00:00	QQQ	ETF	366.61	366.69	365.62	366.52	3381679.0
2021-08-10 11:30:00	QQQ	ETF	366.53	367.15	366.39	366.86	1451608.0
2021-08-10 12:00:00	QQQ	ETF	366.86	367.832	366.84	367.52	1538105.0
2021-08-10 12:30:00	QQQ	ETF	367.53	367.5302	367.055	367.075	1066290.0

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

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