PREVIEW / etf_30min / 2009-03-11

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-11.parquet
  size:    204 KB
  rows:    6,818

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-03-11 04:00:00	SPY	ETF	72.04	72.26	72.04	72.05	3791.0
2009-03-11 04:30:00	SPY	ETF	71.96	72.01	71.93	72.01	2188.0
2009-03-11 05:00:00	SPY	ETF	72.29	72.39	72.26	72.26	12200.0
2009-03-11 05:30:00	SPY	ETF	72.52	72.91	72.52	72.91	3117.0
2009-03-11 06:00:00	SPY	ETF	72.81	73.51	72.81	73.25	78406.0
2009-03-11 06:30:00	SPY	ETF	73.23	73.28	72.98	73.0	239878.0
2009-03-11 07:00:00	SPY	ETF	73.02	73.3	72.9	73.13	621198.0
2009-03-11 07:30:00	SPY	ETF	73.18	73.2	72.79	72.83	454138.0
2009-03-11 08:00:00	SPY	ETF	72.82	73.25	72.67	73.19	1546052.0
2009-03-11 08:30:00	SPY	ETF	73.18	73.25	71.8	73.02	1620283.0
2009-03-11 09:00:00	SPY	ETF	73.02	73.07	72.94	73.01	1508495.0
2009-03-11 09:30:00	SPY	ETF	73.0	73.75	72.31	73.51	50621596.0
2009-03-11 10:00:00	SPY	ETF	73.51	73.64	73.06	73.52	34333686.0
2009-03-11 10:30:00	SPY	ETF	73.53	73.6	72.96	73.2	25559943.0
2009-03-11 11:00:00	SPY	ETF	73.21	73.42	72.82	72.95	21563948.0
2009-03-11 11:30:00	SPY	ETF	72.941	73.0	72.59	72.95	23507950.0
2009-03-11 12:00:00	SPY	ETF	72.96	73.06	72.58	72.69	15021793.0
2009-03-11 12:30:00	SPY	ETF	72.69	72.8	72.2	72.2	17289759.0
2009-03-11 13:00:00	SPY	ETF	72.21	72.63	72.18	72.28	19292877.0
2009-03-11 13:30:00	SPY	ETF	72.27	72.86	72.25	72.6301	19868455.0
2009-03-11 14:00:00	SPY	ETF	72.64	72.82	71.83	72.06	25357555.0
2009-03-11 14:30:00	SPY	ETF	72.06	72.7	71.87	72.38	23379443.0
2009-03-11 15:00:00	SPY	ETF	72.37	73.17	72.36	72.96	23558517.0
2009-03-11 15:30:00	SPY	ETF	72.96	73.32	72.55	72.6	33067536.0
2009-03-11 16:00:00	SPY	ETF	72.6	73.25	72.11	72.62	10246960.0
2009-03-11 16:30:00	SPY	ETF	72.63	72.64	72.55	72.58	1025681.0
2009-03-11 17:00:00	SPY	ETF	72.57	72.67	72.57	72.65	123681.0
2009-03-11 17:30:00	SPY	ETF	72.65	72.67	72.6	72.6	69423.0
2009-03-11 18:00:00	SPY	ETF	72.6	72.66	72.59	72.64	20555.0
2009-03-11 18:30:00	SPY	ETF	72.64	72.67	72.62	72.66	35185.0
2009-03-11 19:00:00	SPY	ETF	72.62	72.62	72.54	72.54	60552.0
2009-03-11 19:30:00	SPY	ETF	72.54	72.54	72.19	72.19	55394.0
2009-03-11 05:00:00	QQQ	ETF	27.26	27.26	27.26	27.26	321.0
2009-03-11 05:30:00	QQQ	ETF	27.49	27.54	27.49	27.54	200.0
2009-03-11 06:00:00	QQQ	ETF	27.55	27.73	27.55	27.71	2800.0
2009-03-11 06:30:00	QQQ	ETF	27.63	27.63	27.57	27.57	5100.0
2009-03-11 07:00:00	QQQ	ETF	27.57	27.68	27.52	27.6	126544.0
2009-03-11 07:30:00	QQQ	ETF	27.63	27.67	27.56	27.59	276714.0
2009-03-11 08:00:00	QQQ	ETF	27.59	27.67	27.52	27.65	295015.0
2009-03-11 08:30:00	QQQ	ETF	27.64	27.68	27.6	27.64	903988.0
2009-03-11 09:00:00	QQQ	ETF	27.62	27.67	27.6	27.63	943118.0
2009-03-11 09:30:00	QQQ	ETF	27.63	27.86	27.26	27.84	26489782.0
2009-03-11 10:00:00	QQQ	ETF	27.83	27.95	27.68	27.95	17126406.0
2009-03-11 10:30:00	QQQ	ETF	27.95	27.99	27.74	27.87	10963842.0
2009-03-11 11:00:00	QQQ	ETF	27.87	27.93	27.73	27.7601	10517371.0
2009-03-11 11:30:00	QQQ	ETF	27.77	27.78	27.61	27.72	10378967.0
2009-03-11 12:00:00	QQQ	ETF	27.72	27.75	27.56	27.62	6043853.0
2009-03-11 12:30:00	QQQ	ETF	27.6299	27.66	27.5	27.502	8545121.0
2009-03-11 13:00:00	QQQ	ETF	27.51	27.7	27.51	27.58	9501560.0
2009-03-11 13:30:00	QQQ	ETF	27.59	27.81	27.58	27.75	10353354.0

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

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