PREVIEW / etf_30min / 2007-11-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-23.parquet
  size:    85 KB
  rows:    2,854

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
2007-11-23 04:00:00	SPY	ETF	142.71	142.75	142.71	142.75	20100.0
2007-11-23 04:30:00	SPY	ETF	142.68	142.88	142.68	142.88	5900.0
2007-11-23 05:00:00	SPY	ETF	142.98	143.0	142.98	143.0	4000.0
2007-11-23 05:30:00	SPY	ETF	142.85	142.85	142.83	142.83	2500.0
2007-11-23 06:00:00	SPY	ETF	142.72	142.72	142.72	142.72	2500.0
2007-11-23 06:30:00	SPY	ETF	142.66	142.71	142.66	142.68	13500.0
2007-11-23 07:00:00	SPY	ETF	142.71	142.72	142.59	142.62	74300.0
2007-11-23 07:30:00	SPY	ETF	142.61	143.04	142.56	142.96	309100.0
2007-11-23 08:00:00	SPY	ETF	142.99	143.04	142.1	143.03	1535500.0
2007-11-23 08:30:00	SPY	ETF	143.04	143.15	143.0	143.12	397800.0
2007-11-23 09:00:00	SPY	ETF	143.12	143.19	142.81	143.07	2221715.0
2007-11-23 09:30:00	SPY	ETF	143.03	143.26	142.7	143.0	13542306.0
2007-11-23 10:00:00	SPY	ETF	143.0	143.38	142.94	143.14	6112297.0
2007-11-23 10:30:00	SPY	ETF	143.1399	143.51	143.05	143.5	7756845.0
2007-11-23 11:00:00	SPY	ETF	143.5	143.63	143.3	143.55	6823840.0
2007-11-23 11:30:00	SPY	ETF	143.55	144.0	143.47	143.9	9941055.0
2007-11-23 12:00:00	SPY	ETF	143.89	144.21	143.76	144.19	7646110.0
2007-11-23 12:30:00	SPY	ETF	144.19	144.34	143.67	144.18	16098704.0
2007-11-23 13:00:00	SPY	ETF	144.17	144.25	142.57	144.0	2255300.0
2007-11-23 13:30:00	SPY	ETF	143.95	143.95	143.7	143.81	139800.0
2007-11-23 14:00:00	SPY	ETF	143.82	143.9	143.8	143.8	3000.0
2007-11-23 14:30:00	SPY	ETF	143.79	143.94	143.6	143.9	11100.0
2007-11-23 15:00:00	SPY	ETF	143.86	143.95	143.8	143.8	5200.0
2007-11-23 15:30:00	SPY	ETF	143.94	143.94	143.93	143.93	1100.0
2007-11-23 16:00:00	SPY	ETF	144.13	144.13	143.95	143.98	3400.0
2007-11-23 16:30:00	SPY	ETF	143.95	143.95	143.95	143.95	100.0
2007-11-23 04:30:00	QQQ	ETF	49.52	49.52	49.52	49.52	17000.0
2007-11-23 05:00:00	QQQ	ETF	49.62	49.62	49.62	49.62	10000.0
2007-11-23 06:00:00	QQQ	ETF	49.54	49.57	49.54	49.57	26000.0
2007-11-23 06:30:00	QQQ	ETF	49.55	49.55	49.52	49.52	14600.0
2007-11-23 07:00:00	QQQ	ETF	49.53	49.55	49.5	49.5	42500.0
2007-11-23 07:30:00	QQQ	ETF	49.49	49.6	49.49	49.6	91648.0
2007-11-23 08:00:00	QQQ	ETF	49.61	49.65	49.35	49.65	370778.0
2007-11-23 08:30:00	QQQ	ETF	49.65	49.72	49.65	49.68	544133.0
2007-11-23 09:00:00	QQQ	ETF	49.68	49.69	49.57	49.62	347813.0
2007-11-23 09:30:00	QQQ	ETF	49.63	49.69	49.3724	49.49	9799272.0
2007-11-23 10:00:00	QQQ	ETF	49.5	49.6	49.45	49.48	4489178.0
2007-11-23 10:30:00	QQQ	ETF	49.488	49.59	49.45	49.54	3198344.0
2007-11-23 11:00:00	QQQ	ETF	49.54	49.62	49.44	49.53	4849141.0
2007-11-23 11:30:00	QQQ	ETF	49.53	49.76	49.5	49.6801	6644026.0
2007-11-23 12:00:00	QQQ	ETF	49.69	49.91	49.65	49.891	4037283.0
2007-11-23 12:30:00	QQQ	ETF	49.9	49.97	49.76	49.89	10934376.0
2007-11-23 13:00:00	QQQ	ETF	49.88	49.88	49.47	49.82	967968.0
2007-11-23 13:30:00	QQQ	ETF	49.81	49.84	49.81	49.84	30423.0
2007-11-23 14:00:00	QQQ	ETF	49.83	49.84	49.8	49.81	30200.0
2007-11-23 14:30:00	QQQ	ETF	49.8	49.83	49.77	49.8	8700.0
2007-11-23 15:00:00	QQQ	ETF	49.82	49.82	49.8	49.82	10600.0
2007-11-23 15:30:00	QQQ	ETF	49.81	49.82	49.8	49.81	2760.0
2007-11-23 16:00:00	QQQ	ETF	49.83	49.83	49.82	49.82	5000.0
2007-11-23 16:30:00	QQQ	ETF	49.83	49.83	49.83	49.83	790.0

> showing 50 of 2,854 rows — these rows as CSV

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