PREVIEW / stock_30min / 2006-03-22

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-03-22.parquet
  size:    911 KB
  rows:    49,398
  symbols: 2,215

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
2006-03-22 04:30:00	AAPL	Stock	2.2232	2.225	2.2232	2.225	19600.0
2006-03-22 05:00:00	AAPL	Stock	2.2232	2.225	2.2232	2.2232	84000.0
2006-03-22 06:30:00	AAPL	Stock	2.2286	2.25	2.2179	2.25	215320.0
2006-03-22 07:00:00	AAPL	Stock	2.2411	2.2411	2.2321	2.2411	700000.0
2006-03-22 07:30:00	AAPL	Stock	2.2411	2.2529	2.2361	2.2436	1284892.0
2006-03-22 08:00:00	AAPL	Stock	2.2475	2.2554	2.2314	2.2343	9590532.0
2006-03-22 08:30:00	AAPL	Stock	2.2343	2.2364	2.22	2.2239	10028648.0
2006-03-22 09:00:00	AAPL	Stock	2.2239	2.2264	2.2125	2.2196	9786420.0
2006-03-22 09:30:00	AAPL	Stock	2.22	2.2346	2.2039	2.2121	194560100.0
2006-03-22 10:00:00	AAPL	Stock	2.2121	2.2304	2.1989	2.2175	150648904.0
2006-03-22 10:30:00	AAPL	Stock	2.2175	2.2286	2.2075	2.2218	101188472.0
2006-03-22 11:00:00	AAPL	Stock	2.2214	2.2346	2.2186	2.2189	114873388.0
2006-03-22 11:30:00	AAPL	Stock	2.2189	2.2432	2.2189	2.2379	80752812.0
2006-03-22 12:00:00	AAPL	Stock	2.2375	2.2589	2.2371	2.2507	80334324.0
2006-03-22 12:30:00	AAPL	Stock	2.2511	2.2536	2.2357	2.24	56918932.0
2006-03-22 13:00:00	AAPL	Stock	2.24	2.2414	2.2243	2.2243	52509912.0
2006-03-22 13:30:00	AAPL	Stock	2.2246	2.2339	2.2182	2.2193	57540028.0
2006-03-22 14:00:00	AAPL	Stock	2.2186	2.2257	2.2036	2.2043	85646568.0
2006-03-22 14:30:00	AAPL	Stock	2.2043	2.205	2.1882	2.2	131334784.0
2006-03-22 15:00:00	AAPL	Stock	2.1996	2.2198	2.195	2.2079	85590120.0
2006-03-22 15:30:00	AAPL	Stock	2.2082	2.2364	2.1964	2.2021	103441884.0
2006-03-22 16:00:00	AAPL	Stock	2.2025	2.2029	2.1964	2.1986	3947580.0
2006-03-22 16:30:00	AAPL	Stock	2.2	2.2025	2.1968	2.1968	5499620.0
2006-03-22 17:00:00	AAPL	Stock	2.1982	2.2	2.1964	2.2	249200.0
2006-03-22 17:30:00	AAPL	Stock	2.2014	2.205	2.2	2.2021	338156.0
2006-03-22 18:00:00	AAPL	Stock	2.2004	2.2018	2.1975	2.2	270060.0
2006-03-22 04:00:00	MSFT	Stock	27.05	27.05	27.05	27.05	1000.0
2006-03-22 04:30:00	MSFT	Stock	26.98	26.98	26.98	26.98	100.0
2006-03-22 05:00:00	MSFT	Stock	26.95	26.95	26.95	26.95	100.0
2006-03-22 05:30:00	MSFT	Stock	27.0	27.0	27.0	27.0	600.0
2006-03-22 06:30:00	MSFT	Stock	27.0	27.05	27.0	27.05	1100.0
2006-03-22 07:00:00	MSFT	Stock	27.05	27.07	27.05	27.07	11700.0
2006-03-22 07:30:00	MSFT	Stock	27.05	27.14	27.03	27.09	33372.0
2006-03-22 08:00:00	MSFT	Stock	27.07	27.26	27.01	27.14	2283091.0
2006-03-22 08:30:00	MSFT	Stock	27.14	27.2	27.08	27.13	1645248.0
2006-03-22 09:00:00	MSFT	Stock	27.14	27.18	27.05	27.07	1663449.0
2006-03-22 09:30:00	MSFT	Stock	27.08	27.5	26.796	26.96	28938884.0
2006-03-22 10:00:00	MSFT	Stock	26.96	27.06	26.94	26.98	15773671.0
2006-03-22 10:30:00	MSFT	Stock	26.98	27.03	26.92	26.93	10921926.0
2006-03-22 11:00:00	MSFT	Stock	26.93	27.02	26.93	26.99	8251715.0
2006-03-22 11:30:00	MSFT	Stock	26.99	27.05	26.97	27.04	7519889.0
2006-03-22 12:00:00	MSFT	Stock	27.04	27.13	27.03	27.05	9471334.0
2006-03-22 12:30:00	MSFT	Stock	27.05	27.06	26.99	27.03	9437962.0
2006-03-22 13:00:00	MSFT	Stock	27.04	27.08	26.99	27.07	6826345.0
2006-03-22 13:30:00	MSFT	Stock	27.07	27.13	27.05	27.06	6077421.0
2006-03-22 14:00:00	MSFT	Stock	27.05	27.1	26.98	27.0	3702389.0
2006-03-22 14:30:00	MSFT	Stock	26.99	27.02	26.96	27.0	5107671.0
2006-03-22 15:00:00	MSFT	Stock	27.0	27.1	26.99	27.07	8753421.0
2006-03-22 15:30:00	MSFT	Stock	27.07	27.21	27.07	27.14	15968300.0
2006-03-22 16:00:00	MSFT	Stock	27.14	27.2	25.62	27.16	532589.0

> showing 50 of 49,398 rows — these rows as CSV

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