PREVIEW / etf_30min / 2022-05-19

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-19.parquet
  size:    692 KB
  rows:    27,464

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-05-19 04:00:00	SPY	ETF	388.77	389.02	387.67	387.67	42507.0
2022-05-19 04:30:00	SPY	ETF	387.79	387.79	386.4	386.4	98490.0
2022-05-19 05:00:00	SPY	ETF	386.36	386.85	385.94	386.27	110379.0
2022-05-19 05:30:00	SPY	ETF	386.3	386.3	385.41	385.8	62700.0
2022-05-19 06:00:00	SPY	ETF	385.7	386.86	385.7	386.53	60343.0
2022-05-19 06:30:00	SPY	ETF	386.52	388.15	386.06	387.84	331776.0
2022-05-19 07:00:00	SPY	ETF	388.08	389.36	387.09	389.1	386211.0
2022-05-19 07:30:00	SPY	ETF	389.07	389.56	388.3	389.05	359954.0
2022-05-19 08:00:00	SPY	ETF	388.0009	392.66	385.4204	387.96	385751.0
2022-05-19 08:30:00	SPY	ETF	388.08	389.87	386.98	387.74	661716.0
2022-05-19 09:00:00	SPY	ETF	387.7	389.3	387.69	388.56	381615.0
2022-05-19 09:30:00	SPY	ETF	388.56	391.79	387.11	388.64	10455453.0
2022-05-19 10:00:00	SPY	ETF	388.63	391.92	388.25	389.6	5918172.0
2022-05-19 10:30:00	SPY	ETF	389.62	390.72	387.86	389.32	4701977.0
2022-05-19 11:00:00	SPY	ETF	389.29	390.41	388.285	389.5601	3564252.0
2022-05-19 11:30:00	SPY	ETF	389.6	393.34	389.59	391.895	5145772.0
2022-05-19 12:00:00	SPY	ETF	391.95	393.0	390.77	391.7	3620285.0
2022-05-19 12:30:00	SPY	ETF	391.71	391.92	388.82	389.96	4107771.0
2022-05-19 13:00:00	SPY	ETF	389.95	390.58	388.33	389.6397	3950630.0
2022-05-19 13:30:00	SPY	ETF	389.65	392.25	388.48	391.75	3965611.0
2022-05-19 14:00:00	SPY	ETF	391.72	391.8542	390.0	390.8955	3521371.0
2022-05-19 14:30:00	SPY	ETF	390.85	393.13	390.44	392.79	4599015.0
2022-05-19 15:00:00	SPY	ETF	392.81	394.14	389.78	389.83	6002360.0
2022-05-19 15:30:00	SPY	ETF	389.85	391.1	389.04	389.45	10190415.0
2022-05-19 16:00:00	SPY	ETF	389.44	390.602	388.74	389.49	3493062.0
2022-05-19 16:30:00	SPY	ETF	389.51	389.95	389.27	389.62	209633.0
2022-05-19 17:00:00	SPY	ETF	389.51	389.59	389.4	389.57	37994.0
2022-05-19 17:30:00	SPY	ETF	389.55	389.63	389.46	389.5	11837.0
2022-05-19 18:00:00	SPY	ETF	389.52	390.39	389.52	390.23	108838.0
2022-05-19 18:30:00	SPY	ETF	390.2	390.25	389.83	390.02	20200.0
2022-05-19 19:00:00	SPY	ETF	390.01	390.19	389.68	390.19	24876.0
2022-05-19 19:30:00	SPY	ETF	390.13	390.7	390.12	390.52	45269.0
2022-05-19 04:00:00	QQQ	ETF	288.15	288.21	287.05	287.23	106454.0
2022-05-19 04:30:00	QQQ	ETF	287.5	287.5	286.14	286.22	98394.0
2022-05-19 05:00:00	QQQ	ETF	286.22	286.64	285.8	286.03	76056.0
2022-05-19 05:30:00	QQQ	ETF	285.88	286.35	285.45	285.82	62195.0
2022-05-19 06:00:00	QQQ	ETF	285.97	286.9	285.88	286.65	75861.0
2022-05-19 06:30:00	QQQ	ETF	286.67	287.96	286.1	287.86	81041.0
2022-05-19 07:00:00	QQQ	ETF	287.84	288.85	287.08	288.66	244809.0
2022-05-19 07:30:00	QQQ	ETF	288.69	289.12	288.06	288.75	440259.0
2022-05-19 08:00:00	QQQ	ETF	287.72	291.5	285.7	287.97	498628.0
2022-05-19 08:30:00	QQQ	ETF	288.0	288.54	287.09	288.2	405206.0
2022-05-19 09:00:00	QQQ	ETF	288.19	289.66	288.12	289.3	537897.0
2022-05-19 09:30:00	QQQ	ETF	289.29	292.06	287.58	289.96	10662484.0
2022-05-19 10:00:00	QQQ	ETF	289.96	292.78	289.7	290.37	7134923.0
2022-05-19 10:30:00	QQQ	ETF	290.37	292.02	289.39	291.35	4433669.0
2022-05-19 11:00:00	QQQ	ETF	291.34	292.33	290.185	291.23	3151093.0
2022-05-19 11:30:00	QQQ	ETF	291.24	294.39	291.24	293.25	4073132.0
2022-05-19 12:00:00	QQQ	ETF	293.27	293.95	291.9538	292.96	2297911.0
2022-05-19 12:30:00	QQQ	ETF	292.979	293.11	289.84	290.8866	3037153.0

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

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