PREVIEW / etf_30min / 2022-03-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-21.parquet
  size:    673 KB
  rows:    26,814

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-03-21 04:00:00	SPY	ETF	443.34	444.48	443.18	443.72	55017.0
2022-03-21 04:30:00	SPY	ETF	443.76	444.23	443.64	443.81	11875.0
2022-03-21 05:00:00	SPY	ETF	443.99	444.25	443.1	444.1	12363.0
2022-03-21 05:30:00	SPY	ETF	444.33	444.41	443.83	444.0	11873.0
2022-03-21 06:00:00	SPY	ETF	443.85	444.04	443.5	443.5	14660.0
2022-03-21 06:30:00	SPY	ETF	443.48	443.88	443.35	443.88	42158.0
2022-03-21 07:00:00	SPY	ETF	443.86	445.2	443.8	444.75	188409.0
2022-03-21 07:30:00	SPY	ETF	444.85	445.09	444.47	444.65	76823.0
2022-03-21 08:00:00	SPY	ETF	443.9001	445.07	442.43	444.12	288840.0
2022-03-21 08:30:00	SPY	ETF	444.12	444.55	444.0	444.38	236974.0
2022-03-21 09:00:00	SPY	ETF	444.34	444.8	444.08	444.34	579301.0
2022-03-21 09:30:00	SPY	ETF	444.34	446.46	443.82	443.948	8645099.0
2022-03-21 10:00:00	SPY	ETF	443.93	444.28	442.73	442.99	4704468.0
2022-03-21 10:30:00	SPY	ETF	442.99	445.12	442.76	444.88	4523290.0
2022-03-21 11:00:00	SPY	ETF	444.89	445.73	444.35	445.485	3897989.0
2022-03-21 11:30:00	SPY	ETF	445.495	445.78	444.68	445.4644	3125496.0
2022-03-21 12:00:00	SPY	ETF	445.48	445.9	444.69	445.5	2440420.0
2022-03-21 12:30:00	SPY	ETF	445.5	445.56	442.16	442.39	6809577.0
2022-03-21 13:00:00	SPY	ETF	442.41	442.51	440.68	441.3031	4586064.0
2022-03-21 13:30:00	SPY	ETF	441.32	442.66	441.19	442.55	2969074.0
2022-03-21 14:00:00	SPY	ETF	442.54	443.6471	441.73	443.51	3596467.0
2022-03-21 14:30:00	SPY	ETF	443.49	444.01	441.79	441.87	3575924.0
2022-03-21 15:00:00	SPY	ETF	441.88	443.55	441.69	443.4999	3165017.0
2022-03-21 15:30:00	SPY	ETF	443.51	444.485	442.09	444.43	9853828.0
2022-03-21 16:00:00	SPY	ETF	444.44	445.01	444.21	444.87	3188150.0
2022-03-21 16:30:00	SPY	ETF	444.91	445.2	444.89	444.98	211184.0
2022-03-21 17:00:00	SPY	ETF	444.97	445.03	444.7	444.9	56079.0
2022-03-21 17:30:00	SPY	ETF	444.92	444.92	444.7	444.9	36711.0
2022-03-21 18:00:00	SPY	ETF	444.86	444.88	444.39	444.451	82753.0
2022-03-21 18:30:00	SPY	ETF	444.45	444.49	444.24	444.33	41386.0
2022-03-21 19:00:00	SPY	ETF	444.31	444.34	444.08	444.25	58851.0
2022-03-21 19:30:00	SPY	ETF	444.25	444.25	443.67	443.7	62200.0
2022-03-21 04:00:00	QQQ	ETF	350.76	355.0	349.52	349.69	106619.0
2022-03-21 04:30:00	QQQ	ETF	349.71	350.11	349.35	349.6	58826.0
2022-03-21 05:00:00	QQQ	ETF	349.72	350.08	348.96	349.89	38137.0
2022-03-21 05:30:00	QQQ	ETF	350.03	350.34	349.82	350.05	123392.0
2022-03-21 06:00:00	QQQ	ETF	350.01	350.18	349.75	349.75	16649.0
2022-03-21 06:30:00	QQQ	ETF	349.67	350.03	349.6	350.03	32216.0
2022-03-21 07:00:00	QQQ	ETF	349.99	351.38	349.97	351.21	174602.0
2022-03-21 07:30:00	QQQ	ETF	351.23	351.52	350.74	350.88	113178.0
2022-03-21 08:00:00	QQQ	ETF	350.86	351.51	348.95	350.32	425866.0
2022-03-21 08:30:00	QQQ	ETF	350.3	350.5	349.94	350.08	200956.0
2022-03-21 09:00:00	QQQ	ETF	350.06	350.49	349.84	350.12	219367.0
2022-03-21 09:30:00	QQQ	ETF	350.2	352.48	348.21	348.45	7132275.0
2022-03-21 10:00:00	QQQ	ETF	348.53	348.88	346.635	346.72	5154665.0
2022-03-21 10:30:00	QQQ	ETF	346.73	349.81	346.6695	349.49	3939312.0
2022-03-21 11:00:00	QQQ	ETF	349.5	351.88	348.97	351.62	3744865.0
2022-03-21 11:30:00	QQQ	ETF	351.62	352.1594	350.61	351.8109	3524980.0
2022-03-21 12:00:00	QQQ	ETF	351.8717	352.025	350.24	350.94	2698505.0
2022-03-21 12:30:00	QQQ	ETF	351.0	351.0107	347.08	347.235	5378594.0

> showing 50 of 26,814 rows — these rows as CSV

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