PREVIEW / etf_30min / 2007-11-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-27.parquet
  size:    145 KB
  rows:    5,314

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-27 04:00:00	SPY	ETF	142.37	142.71	142.37	142.71	7200.0
2007-11-27 04:30:00	SPY	ETF	142.65	142.65	142.63	142.65	1700.0
2007-11-27 05:00:00	SPY	ETF	142.6	142.6	142.35	142.35	13800.0
2007-11-27 05:30:00	SPY	ETF	142.41	142.41	142.41	142.41	2500.0
2007-11-27 06:00:00	SPY	ETF	142.38	142.4	142.28	142.28	60800.0
2007-11-27 06:30:00	SPY	ETF	142.32	142.37	142.08	142.08	108800.0
2007-11-27 07:00:00	SPY	ETF	142.05	142.21	141.97	142.05	541100.0
2007-11-27 07:30:00	SPY	ETF	142.05	142.05	141.33	141.41	1152200.0
2007-11-27 08:00:00	SPY	ETF	142.05	142.55	141.2	141.45	3800400.0
2007-11-27 08:30:00	SPY	ETF	141.49	142.55	141.36	141.92	2637100.0
2007-11-27 09:00:00	SPY	ETF	141.87	141.94	141.68	141.73	1141520.0
2007-11-27 09:30:00	SPY	ETF	141.74	142.36	141.46	141.97	27982581.0
2007-11-27 10:00:00	SPY	ETF	141.97	141.99	140.95	141.67	34612907.0
2007-11-27 10:30:00	SPY	ETF	141.67	142.82	141.58	142.68	30557023.0
2007-11-27 11:00:00	SPY	ETF	142.68	142.75	142.24	142.49	14403805.0
2007-11-27 11:30:00	SPY	ETF	142.5	143.08	142.45	142.51	14093413.0
2007-11-27 12:00:00	SPY	ETF	142.52	142.69	142.08	142.28	14052585.0
2007-11-27 12:30:00	SPY	ETF	142.27	143.1	142.27	142.74	13792321.0
2007-11-27 13:00:00	SPY	ETF	142.74	143.05	142.58	142.93	7771745.0
2007-11-27 13:30:00	SPY	ETF	142.94	142.97	142.17	142.33	14742565.0
2007-11-27 14:00:00	SPY	ETF	142.34	142.49	141.87	142.21	11634700.0
2007-11-27 14:30:00	SPY	ETF	142.21	142.26	141.16	141.72	25184919.0
2007-11-27 15:00:00	SPY	ETF	141.72	142.22	141.43	141.71	16427905.0
2007-11-27 15:30:00	SPY	ETF	141.71	143.23	141.63	143.09	29877513.0
2007-11-27 16:00:00	SPY	ETF	143.06	143.08	141.4894	142.61	8638700.0
2007-11-27 16:30:00	SPY	ETF	142.61	142.75	142.37	142.53	11699200.0
2007-11-27 17:00:00	SPY	ETF	142.53	142.62	142.45	142.51	5668700.0
2007-11-27 17:30:00	SPY	ETF	142.57	142.58	142.44	142.5	258000.0
2007-11-27 18:00:00	SPY	ETF	142.5	142.65	142.5	142.57	90000.0
2007-11-27 18:30:00	SPY	ETF	142.56	142.7	142.56	142.65	22000.0
2007-11-27 19:00:00	SPY	ETF	142.69	142.76	142.64	142.75	22400.0
2007-11-27 19:30:00	SPY	ETF	142.72	142.79	142.5	142.53	24200.0
2007-11-27 04:00:00	QQQ	ETF	49.52	49.52	49.52	49.52	300.0
2007-11-27 04:30:00	QQQ	ETF	49.53	49.53	49.53	49.53	600.0
2007-11-27 05:00:00	QQQ	ETF	49.46	49.48	49.46	49.48	10200.0
2007-11-27 05:30:00	QQQ	ETF	49.5	49.5	49.5	49.5	12500.0
2007-11-27 06:00:00	QQQ	ETF	49.42	49.42	49.42	49.42	10000.0
2007-11-27 06:30:00	QQQ	ETF	49.45	49.45	49.39	49.44	71000.0
2007-11-27 07:00:00	QQQ	ETF	49.36	49.4	49.34	49.38	78900.0
2007-11-27 07:30:00	QQQ	ETF	49.38	49.39	49.25	49.27	136618.0
2007-11-27 08:00:00	QQQ	ETF	49.27	49.53	49.19	49.19	668798.0
2007-11-27 08:30:00	QQQ	ETF	49.2	49.42	49.19	49.39	598196.0
2007-11-27 09:00:00	QQQ	ETF	49.41	49.45	49.36	49.39	424132.0
2007-11-27 09:30:00	QQQ	ETF	49.4	49.73	49.29	49.57	24869962.0
2007-11-27 10:00:00	QQQ	ETF	49.57	49.61	49.1	49.46	22065485.0
2007-11-27 10:30:00	QQQ	ETF	49.45	50.0	49.45	49.96	19507347.0
2007-11-27 11:00:00	QQQ	ETF	49.97	50.0	49.76	49.8601	8998571.0
2007-11-27 11:30:00	QQQ	ETF	49.86	50.05	49.75	49.78	12433880.0
2007-11-27 12:00:00	QQQ	ETF	49.78	49.87	49.69	49.74	8025949.0
2007-11-27 12:30:00	QQQ	ETF	49.74	50.04	49.74	49.8305	7728508.0

> showing 50 of 5,314 rows — these rows as CSV

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