PREVIEW / etf_30min / 2023-03-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-14.parquet
  size:    698 KB
  rows:    28,216

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-03-14 04:00:00	SPY	ETF	386.93	387.2	386.29	386.95	9584.0
2023-03-14 04:30:00	SPY	ETF	387.13	387.64	386.83	387.6	24283.0
2023-03-14 05:00:00	SPY	ETF	387.51	387.53	386.14	386.75	22750.0
2023-03-14 05:30:00	SPY	ETF	386.69	387.08	386.36	386.81	26682.0
2023-03-14 06:00:00	SPY	ETF	386.8	387.33	386.4	387.17	81936.0
2023-03-14 06:30:00	SPY	ETF	387.23	387.24	386.57	387.09	21037.0
2023-03-14 07:00:00	SPY	ETF	387.0	388.33	386.65	387.96	225000.0
2023-03-14 07:30:00	SPY	ETF	387.9	388.43	387.75	387.96	245409.0
2023-03-14 08:00:00	SPY	ETF	387.8	388.96	385.5	388.61	625185.0
2023-03-14 08:30:00	SPY	ETF	388.05	390.12	384.7	389.59	2543315.0
2023-03-14 09:00:00	SPY	ETF	389.57	390.57	389.36	390.48	1095508.0
2023-03-14 09:30:00	SPY	ETF	390.5	391.92	389.9014	391.13	14995105.0
2023-03-14 10:00:00	SPY	ETF	391.14	392.3	390.56	392.23	7987604.0
2023-03-14 10:30:00	SPY	ETF	392.23	392.995	391.94	391.99	6428396.0
2023-03-14 11:00:00	SPY	ETF	392.0	393.45	391.9	393.06	4816132.0
2023-03-14 11:30:00	SPY	ETF	393.06	393.4	392.47	392.53	4224763.0
2023-03-14 12:00:00	SPY	ETF	392.52	392.82	391.57	391.7301	3988362.0
2023-03-14 12:30:00	SPY	ETF	391.735	392.51	391.09	391.43	4751988.0
2023-03-14 13:00:00	SPY	ETF	391.44	391.72	388.55	389.8007	8735071.0
2023-03-14 13:30:00	SPY	ETF	389.81	390.5291	388.8	389.1691	5380527.0
2023-03-14 14:00:00	SPY	ETF	389.17	389.6407	387.7084	389.43	5819436.0
2023-03-14 14:30:00	SPY	ETF	389.4	390.0	388.73	388.87	4737559.0
2023-03-14 15:00:00	SPY	ETF	388.87	389.39	387.05	388.215	7997065.0
2023-03-14 15:30:00	SPY	ETF	388.21	392.18	387.93	391.69	22418281.0
2023-03-14 16:00:00	SPY	ETF	391.695	391.86	391.07	391.65	5052363.0
2023-03-14 16:30:00	SPY	ETF	391.66	392.13	391.65	392.0	1065427.0
2023-03-14 17:00:00	SPY	ETF	391.81	392.03	391.81	391.96	41427.0
2023-03-14 17:30:00	SPY	ETF	391.97	392.0	391.73	391.74	131834.0
2023-03-14 18:00:00	SPY	ETF	391.76	391.82	391.38	391.41	143713.0
2023-03-14 18:30:00	SPY	ETF	391.38	391.45	391.25	391.33	54080.0
2023-03-14 19:00:00	SPY	ETF	391.35	391.75	391.35	391.66	46455.0
2023-03-14 19:30:00	SPY	ETF	391.66	391.73	391.35	391.63	68394.0
2023-03-14 04:00:00	QQQ	ETF	291.77	292.31	291.49	292.28	32397.0
2023-03-14 04:30:00	QQQ	ETF	292.35	292.55	292.04	292.39	33491.0
2023-03-14 05:00:00	QQQ	ETF	292.37	292.37	291.46	291.87	30845.0
2023-03-14 05:30:00	QQQ	ETF	291.86	292.25	291.5	291.51	38256.0
2023-03-14 06:00:00	QQQ	ETF	291.53	291.91	291.2	291.9	40383.0
2023-03-14 06:30:00	QQQ	ETF	291.91	292.07	291.42	291.85	18305.0
2023-03-14 07:00:00	QQQ	ETF	292.01	292.88	291.9	292.6	101533.0
2023-03-14 07:30:00	QQQ	ETF	292.62	293.01	292.39	292.49	169501.0
2023-03-14 08:00:00	QQQ	ETF	292.05	293.37	290.908	293.31	413693.0
2023-03-14 08:30:00	QQQ	ETF	293.17	294.6	289.0	293.8	2348128.0
2023-03-14 09:00:00	QQQ	ETF	293.79	294.5	292.15	294.2	611424.0
2023-03-14 09:30:00	QQQ	ETF	294.31	296.38	294.21	295.65	10206150.0
2023-03-14 10:00:00	QQQ	ETF	295.65	296.82	295.31	296.76	5114298.0
2023-03-14 10:30:00	QQQ	ETF	296.77	297.23	296.3	296.37	3266660.0
2023-03-14 11:00:00	QQQ	ETF	296.36	297.75	296.35	297.55	2363835.0
2023-03-14 11:30:00	QQQ	ETF	297.545	297.93	297.36	297.4	2207966.0
2023-03-14 12:00:00	QQQ	ETF	297.4	297.6999	296.63	296.92	1975205.0
2023-03-14 12:30:00	QQQ	ETF	296.93	297.66	296.685	297.042	2266366.0

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

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