PREVIEW / etf_30min / 2023-01-09

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-09.parquet
  size:    714 KB
  rows:    28,332

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
2023-01-09 04:00:00	SPY	ETF	388.37	389.55	388.37	389.32	18110.0
2023-01-09 04:30:00	SPY	ETF	389.34	389.8	389.29	389.4	23834.0
2023-01-09 05:00:00	SPY	ETF	389.35	389.9	389.31	389.72	22879.0
2023-01-09 05:30:00	SPY	ETF	389.74	389.74	389.39	389.68	11409.0
2023-01-09 06:00:00	SPY	ETF	389.65	389.8	389.28	389.4	14450.0
2023-01-09 06:30:00	SPY	ETF	389.32	389.5	389.22	389.31	11076.0
2023-01-09 07:00:00	SPY	ETF	389.3	389.73	389.3	389.52	144107.0
2023-01-09 07:30:00	SPY	ETF	389.57	390.05	389.54	389.65	157659.0
2023-01-09 08:00:00	SPY	ETF	389.5	390.05	388.5	389.969	286945.0
2023-01-09 08:30:00	SPY	ETF	389.95	390.29	389.6	389.66	142995.0
2023-01-09 09:00:00	SPY	ETF	389.67	390.53	389.58	390.37	323216.0
2023-01-09 09:30:00	SPY	ETF	390.37	391.67	389.35	391.6	6135107.0
2023-01-09 10:00:00	SPY	ETF	391.62	392.16	391.21	391.419	4116742.0
2023-01-09 10:30:00	SPY	ETF	391.4201	393.25	391.42	392.6	4019799.0
2023-01-09 11:00:00	SPY	ETF	392.6	393.7	392.6	393.52	2923325.0
2023-01-09 11:30:00	SPY	ETF	393.525	393.638	392.82	393.38	2863663.0
2023-01-09 12:00:00	SPY	ETF	393.38	393.38	392.43	392.91	2076740.0
2023-01-09 12:30:00	SPY	ETF	392.91	392.97	391.86	392.32	2635220.0
2023-01-09 13:00:00	SPY	ETF	392.325	392.47	391.51	392.0	2582637.0
2023-01-09 13:30:00	SPY	ETF	391.995	392.04	389.87	390.485	4933143.0
2023-01-09 14:00:00	SPY	ETF	390.49	391.12	389.9	390.56	4010700.0
2023-01-09 14:30:00	SPY	ETF	390.565	390.74	388.76	388.95	3109127.0
2023-01-09 15:00:00	SPY	ETF	388.9495	389.22	388.19	388.3599	5302631.0
2023-01-09 15:30:00	SPY	ETF	388.36	388.55	387.67	387.8657	8907434.0
2023-01-09 16:00:00	SPY	ETF	387.87	387.95	387.51	387.74	3348115.0
2023-01-09 16:30:00	SPY	ETF	387.86	387.86	387.6	387.79	287163.0
2023-01-09 17:00:00	SPY	ETF	387.82	387.94	387.6	387.75	81423.0
2023-01-09 17:30:00	SPY	ETF	387.75	387.86	387.66	387.81	26289.0
2023-01-09 18:00:00	SPY	ETF	387.83	387.92	387.67	387.78	49598.0
2023-01-09 18:30:00	SPY	ETF	387.74	387.8	387.38	387.54	19877.0
2023-01-09 19:00:00	SPY	ETF	387.6	387.66	386.8	386.95	47900.0
2023-01-09 19:30:00	SPY	ETF	386.92	387.21	386.91	387.15	75344.0
2023-01-09 04:00:00	QQQ	ETF	268.83	270.2	268.83	270.01	55291.0
2023-01-09 04:30:00	QQQ	ETF	270.03	270.5	269.91	270.02	38540.0
2023-01-09 05:00:00	QQQ	ETF	270.0	270.29	269.82	270.01	31621.0
2023-01-09 05:30:00	QQQ	ETF	269.88	269.97	269.71	269.88	7893.0
2023-01-09 06:00:00	QQQ	ETF	269.82	270.05	269.46	269.59	32540.0
2023-01-09 06:30:00	QQQ	ETF	269.59	269.84	269.55	269.64	12370.0
2023-01-09 07:00:00	QQQ	ETF	269.67	270.01	269.61	269.98	50299.0
2023-01-09 07:30:00	QQQ	ETF	269.91	270.41	269.91	270.18	82921.0
2023-01-09 08:00:00	QQQ	ETF	269.88	270.45	269.14	270.42	201815.0
2023-01-09 08:30:00	QQQ	ETF	270.42	270.73	270.18	270.26	244682.0
2023-01-09 09:00:00	QQQ	ETF	270.22	270.93	270.17	270.8	366568.0
2023-01-09 09:30:00	QQQ	ETF	270.82	273.5401	270.73	273.52	6949754.0
2023-01-09 10:00:00	QQQ	ETF	273.53	273.855	272.76	273.26	3793359.0
2023-01-09 10:30:00	QQQ	ETF	273.29	274.79	273.28	274.0823	2701781.0
2023-01-09 11:00:00	QQQ	ETF	274.09	275.29	274.07	275.03	2165028.0
2023-01-09 11:30:00	QQQ	ETF	275.03	275.19	274.45	274.92	1679523.0
2023-01-09 12:00:00	QQQ	ETF	274.94	275.02	274.45	274.925	1295502.0
2023-01-09 12:30:00	QQQ	ETF	274.9	274.99	273.98	274.565	1545279.0

> showing 50 of 28,332 rows — these rows as CSV

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