PREVIEW / stock_30min / 2007-04-16

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-16.parquet
  size:    1.1 MB
  rows:    57,122
  symbols: 2,594

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-04-16 07:00:00	AAPL	Stock	3.2393	3.2393	3.2371	3.2371	37492.0
2007-04-16 07:30:00	AAPL	Stock	3.2425	3.2425	3.2389	3.2389	31584.0
2007-04-16 08:00:00	AAPL	Stock	3.2418	3.2429	3.2236	3.2321	1093680.0
2007-04-16 08:30:00	AAPL	Stock	3.2321	3.2357	3.2239	3.2268	1993880.0
2007-04-16 09:00:00	AAPL	Stock	3.2311	3.2361	3.2268	3.2354	1399524.0
2007-04-16 09:30:00	AAPL	Stock	3.2346	3.2436	3.2232	3.2343	100157008.0
2007-04-16 10:00:00	AAPL	Stock	3.2343	3.2393	3.23	3.2343	38647840.0
2007-04-16 10:30:00	AAPL	Stock	3.2339	3.2639	3.2339	3.2536	89653480.0
2007-04-16 11:00:00	AAPL	Stock	3.2536	3.2546	3.2432	3.2446	32565400.0
2007-04-16 11:30:00	AAPL	Stock	3.2446	3.2679	3.2446	3.2636	67802700.0
2007-04-16 12:00:00	AAPL	Stock	3.2639	3.2657	3.2536	3.2575	39411344.0
2007-04-16 12:30:00	AAPL	Stock	3.2571	3.2625	3.2557	3.2596	22248464.0
2007-04-16 13:00:00	AAPL	Stock	3.2596	3.2643	3.2536	3.2554	33562088.0
2007-04-16 13:30:00	AAPL	Stock	3.2554	3.2589	3.2532	3.2543	22732584.0
2007-04-16 14:00:00	AAPL	Stock	3.2543	3.2554	3.25	3.2546	23023952.0
2007-04-16 14:30:00	AAPL	Stock	3.2546	3.2596	3.2543	3.2586	26821284.0
2007-04-16 15:00:00	AAPL	Stock	3.2589	3.2668	3.2575	3.2636	33936672.0
2007-04-16 15:30:00	AAPL	Stock	3.2636	3.2661	3.2536	3.2661	49093464.0
2007-04-16 16:00:00	AAPL	Stock	3.2654	3.27	3.2625	3.2679	5245744.0
2007-04-16 16:30:00	AAPL	Stock	3.2679	3.2682	3.2654	3.2675	580384.0
2007-04-16 17:00:00	AAPL	Stock	3.2679	3.2679	3.2654	3.2679	94948.0
2007-04-16 17:30:00	AAPL	Stock	3.2657	3.2679	3.2657	3.2679	73724.0
2007-04-16 18:00:00	AAPL	Stock	3.2679	3.2682	3.2671	3.2682	47040.0
2007-04-16 18:30:00	AAPL	Stock	3.2668	3.2679	3.2668	3.2679	21924.0
2007-04-16 19:00:00	AAPL	Stock	3.2679	3.2682	3.2679	3.2682	88340.0
2007-04-16 19:30:00	AAPL	Stock	3.2686	3.2704	3.2679	3.2689	184800.0
2007-04-16 07:00:00	MSFT	Stock	28.61	28.61	28.61	28.61	1300.0
2007-04-16 08:00:00	MSFT	Stock	28.61	28.65	28.61	28.65	1650.0
2007-04-16 08:30:00	MSFT	Stock	28.65	28.65	28.62	28.65	23250.0
2007-04-16 09:00:00	MSFT	Stock	28.63	28.65	28.6	28.61	48379.0
2007-04-16 09:30:00	MSFT	Stock	28.6	28.75	28.54	28.65	3712735.0
2007-04-16 10:00:00	MSFT	Stock	28.66	28.69	28.21	28.56	2711979.0
2007-04-16 10:30:00	MSFT	Stock	28.562	28.6	28.47	28.58	2088218.0
2007-04-16 11:00:00	MSFT	Stock	28.582	28.66	28.55	28.64	1681834.0
2007-04-16 11:30:00	MSFT	Stock	28.64	28.73	28.64	28.66	1933085.0
2007-04-16 12:00:00	MSFT	Stock	28.65	28.67	28.6	28.6	1125294.0
2007-04-16 12:30:00	MSFT	Stock	28.6	28.71	28.6	28.65	1023539.0
2007-04-16 13:00:00	MSFT	Stock	28.65	28.73	28.64	28.68	1523301.0
2007-04-16 13:30:00	MSFT	Stock	28.68	28.72	28.632	28.65	1801102.0
2007-04-16 14:00:00	MSFT	Stock	28.64	28.7	28.62	28.69	1027120.0
2007-04-16 14:30:00	MSFT	Stock	28.69	28.74	28.69	28.73	1381284.0
2007-04-16 15:00:00	MSFT	Stock	28.73	28.75	28.7	28.71	2425148.0
2007-04-16 15:30:00	MSFT	Stock	28.72	28.73	28.65	28.72	4854189.0
2007-04-16 16:00:00	MSFT	Stock	28.71	28.73	28.7	28.7	795474.0
2007-04-16 16:30:00	MSFT	Stock	28.71	28.71	28.71	28.71	1100.0
2007-04-16 17:00:00	MSFT	Stock	28.71	28.73	28.71	28.73	1000100.0
2007-04-16 17:30:00	MSFT	Stock	28.71	28.71	28.71	28.71	100.0
2007-04-16 18:00:00	MSFT	Stock	28.7	28.7	28.7	28.7	2000.0
2007-04-16 18:30:00	MSFT	Stock	28.7	28.7	28.7	28.7	350.0
2007-04-16 19:00:00	MSFT	Stock	28.7	28.713	28.7	28.713	414.0

> showing 50 of 57,122 rows — these rows as CSV

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