PREVIEW / etf_30min / 2022-01-26

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-26.parquet
  size:    701 KB
  rows:    27,918

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-01-26 04:00:00	SPY	ETF	436.0	440.0	436.0	439.5	47889.0
2022-01-26 04:30:00	SPY	ETF	439.28	440.51	439.28	439.52	44074.0
2022-01-26 05:00:00	SPY	ETF	439.43	439.83	438.81	439.3	23744.0
2022-01-26 05:30:00	SPY	ETF	439.69	440.39	439.59	440.01	22278.0
2022-01-26 06:00:00	SPY	ETF	440.49	440.79	439.96	440.11	91315.0
2022-01-26 06:30:00	SPY	ETF	440.09	441.25	440.09	441.25	265913.0
2022-01-26 07:00:00	SPY	ETF	441.23	441.3	439.37	440.01	295768.0
2022-01-26 07:30:00	SPY	ETF	440.18	440.36	439.5	440.01	200137.0
2022-01-26 08:00:00	SPY	ETF	440.87	441.72	434.1	441.26	751012.0
2022-01-26 08:30:00	SPY	ETF	441.23	441.67	440.56	441.06	361857.0
2022-01-26 09:00:00	SPY	ETF	441.06	441.31	439.62	440.72	721541.0
2022-01-26 09:30:00	SPY	ETF	440.72	442.35	438.79	441.95	10277273.0
2022-01-26 10:00:00	SPY	ETF	441.97	443.0978	438.54	439.18	9073735.0
2022-01-26 10:30:00	SPY	ETF	439.1799	439.5	437.54	439.12	6720365.0
2022-01-26 11:00:00	SPY	ETF	439.1	441.085	438.25	440.64	5487272.0
2022-01-26 11:30:00	SPY	ETF	440.63	441.4001	439.73	440.6999	4456623.0
2022-01-26 12:00:00	SPY	ETF	440.7	441.64	440.54	441.43	3988327.0
2022-01-26 12:30:00	SPY	ETF	441.44	442.12	440.97	441.92	3334220.0
2022-01-26 13:00:00	SPY	ETF	441.91	442.02	440.04	440.79	4629368.0
2022-01-26 13:30:00	SPY	ETF	440.79	441.33	440.34	440.74	4005793.0
2022-01-26 14:00:00	SPY	ETF	440.7404	444.04	438.72	441.48	16379571.0
2022-01-26 14:30:00	SPY	ETF	441.48	442.13	434.41	436.34	20108136.0
2022-01-26 15:00:00	SPY	ETF	436.32	436.3499	428.86	432.96	22688903.0
2022-01-26 15:30:00	SPY	ETF	432.94	434.55	430.6	433.46	25515033.0
2022-01-26 16:00:00	SPY	ETF	433.46	433.79	432.1	432.99	3801041.0
2022-01-26 16:30:00	SPY	ETF	432.97	433.53	432.12	433.24	490980.0
2022-01-26 17:00:00	SPY	ETF	433.45	433.95	433.2	433.75	226264.0
2022-01-26 17:30:00	SPY	ETF	433.74	434.71	433.5	434.1	76250.0
2022-01-26 18:00:00	SPY	ETF	434.2	435.83	434.0	435.6	174659.0
2022-01-26 18:30:00	SPY	ETF	433.38	436.22	433.38	435.91	67294.0
2022-01-26 19:00:00	SPY	ETF	436.03	436.09	434.16	434.38	78391.0
2022-01-26 19:30:00	SPY	ETF	434.41	434.45	432.4	432.95	133293.0
2022-01-26 04:00:00	QQQ	ETF	347.0	351.11	347.0	350.56	297284.0
2022-01-26 04:30:00	QQQ	ETF	350.63	352.04	350.52	351.15	85515.0
2022-01-26 05:00:00	QQQ	ETF	350.99	351.55	350.32	351.19	55028.0
2022-01-26 05:30:00	QQQ	ETF	351.25	351.83	351.25	351.33	28959.0
2022-01-26 06:00:00	QQQ	ETF	351.28	352.35	351.28	351.61	67970.0
2022-01-26 06:30:00	QQQ	ETF	351.65	352.6	351.65	352.56	117881.0
2022-01-26 07:00:00	QQQ	ETF	352.53	352.55	350.38	351.02	363980.0
2022-01-26 07:30:00	QQQ	ETF	350.97	351.52	350.73	351.44	187451.0
2022-01-26 08:00:00	QQQ	ETF	351.45	353.62	345.12	353.04	575491.0
2022-01-26 08:30:00	QQQ	ETF	353.04	353.17	351.98	352.62	620380.0
2022-01-26 09:00:00	QQQ	ETF	352.4	352.93	351.58	352.89	522711.0
2022-01-26 09:30:00	QQQ	ETF	352.91	353.47	349.8501	352.365	7687246.0
2022-01-26 10:00:00	QQQ	ETF	352.37	353.83	350.0	350.64	6225555.0
2022-01-26 10:30:00	QQQ	ETF	350.64	351.49	349.23	350.8	5724397.0
2022-01-26 11:00:00	QQQ	ETF	350.8	352.37	349.62	351.815	3627636.0
2022-01-26 11:30:00	QQQ	ETF	351.85	352.83	351.4501	352.2051	2830261.0
2022-01-26 12:00:00	QQQ	ETF	352.21	353.425	352.05	353.37	2771194.0
2022-01-26 12:30:00	QQQ	ETF	353.37	354.6372	352.96	354.3201	3250616.0

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

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