PREVIEW / etf_30min / 2009-01-12

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-12.parquet
  size:    201 KB
  rows:    6,608

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
2009-01-12 04:00:00	SPY	ETF	88.85	88.85	88.85	88.85	1000.0
2009-01-12 05:00:00	SPY	ETF	88.67	88.78	88.67	88.78	2200.0
2009-01-12 05:30:00	SPY	ETF	88.61	88.79	88.61	88.79	200.0
2009-01-12 06:00:00	SPY	ETF	88.74	88.85	88.69	88.69	17500.0
2009-01-12 06:30:00	SPY	ETF	88.69	88.78	88.65	88.78	31700.0
2009-01-12 07:00:00	SPY	ETF	88.8	88.92	88.79	88.92	80834.0
2009-01-12 07:30:00	SPY	ETF	88.87	88.87	88.67	88.67	117025.0
2009-01-12 08:00:00	SPY	ETF	88.69	88.7	88.56	88.69	397412.0
2009-01-12 08:30:00	SPY	ETF	88.68	88.86	88.66	88.75	631302.0
2009-01-12 09:00:00	SPY	ETF	88.75	88.86	88.64	88.81	787117.0
2009-01-12 09:30:00	SPY	ETF	88.84	88.91	88.08	88.3908	25819011.0
2009-01-12 10:00:00	SPY	ETF	88.39	88.4	87.76	88.0695	20874917.0
2009-01-12 10:30:00	SPY	ETF	88.06	88.3	88.0	88.02	11472298.0
2009-01-12 11:00:00	SPY	ETF	88.02	88.1	87.74	87.81	13104247.0
2009-01-12 11:30:00	SPY	ETF	87.81	87.88	87.44	87.44	15320960.0
2009-01-12 12:00:00	SPY	ETF	87.44	87.69	87.35	87.57	11496462.0
2009-01-12 12:30:00	SPY	ETF	87.58	87.76	87.43	87.49	9568300.0
2009-01-12 13:00:00	SPY	ETF	87.49	87.75	87.44	87.57	8888462.0
2009-01-12 13:30:00	SPY	ETF	87.57	87.8	87.4	87.5	10157776.0
2009-01-12 14:00:00	SPY	ETF	87.5	87.505	87.06	87.12	16795798.0
2009-01-12 14:30:00	SPY	ETF	87.12	87.13	86.68	86.87	18779697.0
2009-01-12 15:00:00	SPY	ETF	86.87	87.09	86.58	86.84	22619446.0
2009-01-12 15:30:00	SPY	ETF	86.83	88.55	86.41	87.0	42730826.0
2009-01-12 16:00:00	SPY	ETF	86.95	88.0	86.93	87.2	11790764.0
2009-01-12 16:30:00	SPY	ETF	87.21	87.4	87.12	87.37	1519586.0
2009-01-12 17:00:00	SPY	ETF	87.36	89.0598	87.34	87.4	2342421.0
2009-01-12 17:30:00	SPY	ETF	87.41	87.41	87.3	87.33	382157.0
2009-01-12 18:00:00	SPY	ETF	87.35	87.54	87.34	87.54	230509.0
2009-01-12 18:30:00	SPY	ETF	87.5	87.5	87.37	87.43	32872.0
2009-01-12 19:00:00	SPY	ETF	87.45	87.51	87.4	87.45	54419.0
2009-01-12 19:30:00	SPY	ETF	87.45	87.47	87.38	87.47	30724.0
2009-01-12 07:00:00	QQQ	ETF	30.1	30.12	30.09	30.1	11404.0
2009-01-12 07:30:00	QQQ	ETF	30.1	30.1	30.05	30.05	1600.0
2009-01-12 08:00:00	QQQ	ETF	30.06	30.06	29.98	30.03	101249.0
2009-01-12 08:30:00	QQQ	ETF	30.03	30.15	30.03	30.07	137820.0
2009-01-12 09:00:00	QQQ	ETF	30.05	30.15	30.03	30.11	197765.0
2009-01-12 09:30:00	QQQ	ETF	30.11	30.15	29.79	29.95	8843064.0
2009-01-12 10:00:00	QQQ	ETF	29.95	29.98	29.69	29.7901	8550522.0
2009-01-12 10:30:00	QQQ	ETF	29.8	29.86	29.76	29.78	5310580.0
2009-01-12 11:00:00	QQQ	ETF	29.77	29.8	29.63	29.65	5041595.0
2009-01-12 11:30:00	QQQ	ETF	29.66	29.67	29.4701	29.491	6427521.0
2009-01-12 12:00:00	QQQ	ETF	29.49	29.6	29.44	29.56	5571730.0
2009-01-12 12:30:00	QQQ	ETF	29.56	29.62	29.5	29.52	2792133.0
2009-01-12 13:00:00	QQQ	ETF	29.53	29.62	29.49	29.541	2798293.0
2009-01-12 13:30:00	QQQ	ETF	29.5499	29.61	29.5	29.52	3931585.0
2009-01-12 14:00:00	QQQ	ETF	29.51	29.51	29.36	29.4	5631439.0
2009-01-12 14:30:00	QQQ	ETF	29.409	29.46	29.2	29.42	13663984.0
2009-01-12 15:00:00	QQQ	ETF	29.42	29.53	29.36	29.459	10798391.0
2009-01-12 15:30:00	QQQ	ETF	29.45	29.63	29.3	29.52	18878185.0
2009-01-12 16:00:00	QQQ	ETF	29.53	29.66	29.51	29.63	1843249.0

> showing 50 of 6,608 rows — these rows as CSV

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