PREVIEW / etf_30min / 2007-01-31

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-31.parquet
  size:    100 KB
  rows:    3,412

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-01-31 04:30:00	SPY	ETF	142.6	142.6	142.6	142.6	800.0
2007-01-31 07:00:00	SPY	ETF	142.52	142.55	142.46	142.48	18200.0
2007-01-31 07:30:00	SPY	ETF	142.56	142.61	142.54	142.56	61100.0
2007-01-31 08:00:00	SPY	ETF	142.58	142.67	142.52	142.63	1446400.0
2007-01-31 08:30:00	SPY	ETF	142.66	142.78	142.56	142.62	1722000.0
2007-01-31 09:00:00	SPY	ETF	142.62	142.7	142.6	142.64	269400.0
2007-01-31 09:30:00	SPY	ETF	142.63	142.69	142.4	142.46	5647200.0
2007-01-31 10:00:00	SPY	ETF	142.46	142.79	142.42	142.73	5625800.0
2007-01-31 10:30:00	SPY	ETF	142.74	143.01	142.72	142.9	5159400.0
2007-01-31 11:00:00	SPY	ETF	142.89	142.91	142.74	142.79	4212900.0
2007-01-31 11:30:00	SPY	ETF	142.79	142.94	142.79	142.88	1327100.0
2007-01-31 12:00:00	SPY	ETF	142.88	142.93	142.74	142.77	1797600.0
2007-01-31 12:30:00	SPY	ETF	142.77	142.87	142.69	142.83	3450100.0
2007-01-31 13:00:00	SPY	ETF	142.84	142.87	142.79	142.86	948100.0
2007-01-31 13:30:00	SPY	ETF	142.86	142.92	142.79	142.86	1489800.0
2007-01-31 14:00:00	SPY	ETF	142.87	143.49	142.66	143.25	18838500.0
2007-01-31 14:30:00	SPY	ETF	143.26	143.91	143.21	143.81	13195500.0
2007-01-31 15:00:00	SPY	ETF	143.81	144.08	143.79	144.01	10706900.0
2007-01-31 15:30:00	SPY	ETF	144.01	144.13	143.71	143.81	8631500.0
2007-01-31 16:00:00	SPY	ETF	143.82	143.85	143.61	143.76	2220700.0
2007-01-31 16:30:00	SPY	ETF	143.72	143.74	143.59	143.74	1003500.0
2007-01-31 17:00:00	SPY	ETF	143.72	143.8	143.67	143.8	56400.0
2007-01-31 17:30:00	SPY	ETF	143.8	143.8	143.76	143.76	3600.0
2007-01-31 18:00:00	SPY	ETF	143.8	143.8	143.74	143.74	17500.0
2007-01-31 19:00:00	SPY	ETF	143.74	143.74	143.72	143.74	1800.0
2007-01-31 19:30:00	SPY	ETF	143.78	143.8	143.78	143.8	15300.0
2007-01-31 06:00:00	QQQ	ETF	43.57	43.57	43.57	43.57	21600.0
2007-01-31 06:30:00	QQQ	ETF	43.57	43.57	43.57	43.57	28400.0
2007-01-31 07:00:00	QQQ	ETF	43.55	43.58	43.55	43.57	23100.0
2007-01-31 07:30:00	QQQ	ETF	43.59	43.59	43.58	43.58	62000.0
2007-01-31 08:00:00	QQQ	ETF	43.57	43.6	43.53	43.6	1477549.0
2007-01-31 08:30:00	QQQ	ETF	43.6	43.65	43.57	43.61	1258592.0
2007-01-31 09:00:00	QQQ	ETF	43.62	43.64	43.58	43.59	174234.0
2007-01-31 09:30:00	QQQ	ETF	43.6	43.63	43.33	43.38	20831400.0
2007-01-31 10:00:00	QQQ	ETF	43.39	43.66	43.37	43.61	13973000.0
2007-01-31 10:30:00	QQQ	ETF	43.6	43.87	43.59	43.77	13828900.0
2007-01-31 11:00:00	QQQ	ETF	43.77	43.78	43.65	43.68	7156900.0
2007-01-31 11:30:00	QQQ	ETF	43.69	43.76	43.66	43.71	3919200.0
2007-01-31 12:00:00	QQQ	ETF	43.72	43.74	43.63	43.64	2002900.0
2007-01-31 12:30:00	QQQ	ETF	43.65	43.7	43.61	43.69	3820600.0
2007-01-31 13:00:00	QQQ	ETF	43.69	43.72	43.66	43.69	2012000.0
2007-01-31 13:30:00	QQQ	ETF	43.7	43.71	43.62	43.65	3449800.0
2007-01-31 14:00:00	QQQ	ETF	43.65	43.91	43.56	43.75	18346300.0
2007-01-31 14:30:00	QQQ	ETF	43.75	44.04	43.71	43.99	15184100.0
2007-01-31 15:00:00	QQQ	ETF	43.99	44.16	43.95	44.13	14734700.0
2007-01-31 15:30:00	QQQ	ETF	44.14	44.19	44.02	44.06	12950600.0
2007-01-31 16:00:00	QQQ	ETF	44.06	44.1	43.85	43.95	8680879.0
2007-01-31 16:30:00	QQQ	ETF	43.95	44.1	43.86	44.03	3016414.0
2007-01-31 17:00:00	QQQ	ETF	44.03	44.09	44.02	44.08	441076.0
2007-01-31 17:30:00	QQQ	ETF	44.07	44.1	44.03	44.07	94306.0

> showing 50 of 3,412 rows — these rows as CSV

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