PREVIEW / stock_30min / 2006-07-27

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-07-27.parquet
  size:    933 KB
  rows:    50,376
  symbols: 2,315

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-07-27 08:00:00	AAPL	Stock	2.3036	2.3161	2.2943	2.2993	1171128.0
2006-07-27 08:30:00	AAPL	Stock	2.3029	2.3029	2.295	2.2982	880516.0
2006-07-27 09:00:00	AAPL	Stock	2.2964	2.3054	2.295	2.3043	1542688.0
2006-07-27 09:30:00	AAPL	Stock	2.3037	2.3179	2.3025	2.3057	108698716.0
2006-07-27 10:00:00	AAPL	Stock	2.3057	2.3221	2.2929	2.3096	89663056.0
2006-07-27 10:30:00	AAPL	Stock	2.3107	2.3146	2.3018	2.3082	51195004.0
2006-07-27 11:00:00	AAPL	Stock	2.3079	2.3096	2.2986	2.305	52202696.0
2006-07-27 11:30:00	AAPL	Stock	2.3046	2.3046	2.2729	2.275	63327880.0
2006-07-27 12:00:00	AAPL	Stock	2.275	2.2942	2.2714	2.2864	35677740.0
2006-07-27 12:30:00	AAPL	Stock	2.2868	2.2889	2.2779	2.2786	18298280.0
2006-07-27 13:00:00	AAPL	Stock	2.2786	2.2804	2.2579	2.2682	59172232.0
2006-07-27 13:30:00	AAPL	Stock	2.2686	2.3214	2.2521	2.2521	45526432.0
2006-07-27 14:00:00	AAPL	Stock	2.2521	2.2614	2.2461	2.2575	52847060.0
2006-07-27 14:30:00	AAPL	Stock	2.2575	2.2625	2.2496	2.2568	34451116.0
2006-07-27 15:00:00	AAPL	Stock	2.2568	2.2607	2.245	2.2482	44974132.0
2006-07-27 15:30:00	AAPL	Stock	2.2482	2.2671	2.2479	2.2643	67007976.0
2006-07-27 16:00:00	AAPL	Stock	2.2636	2.2668	2.2614	2.2646	1433236.0
2006-07-27 16:30:00	AAPL	Stock	2.2643	2.2657	2.2643	2.2646	398244.0
2006-07-27 17:00:00	AAPL	Stock	2.2657	2.2668	2.2575	2.2596	155344.0
2006-07-27 18:00:00	AAPL	Stock	2.2625	2.2625	2.2604	2.2625	50176.0
2006-07-27 08:00:00	MSFT	Stock	24.4	24.45	24.38	24.42	21024.0
2006-07-27 08:30:00	MSFT	Stock	24.43	24.45	24.41	24.45	13800.0
2006-07-27 09:00:00	MSFT	Stock	24.46	24.59	24.45	24.59	109085.0
2006-07-27 09:30:00	MSFT	Stock	24.58	24.6	24.4	24.46	5526821.0
2006-07-27 10:00:00	MSFT	Stock	24.46	24.5	24.35	24.37	3978352.0
2006-07-27 10:30:00	MSFT	Stock	24.37	24.49	24.3	24.48	6076900.0
2006-07-27 11:00:00	MSFT	Stock	24.49	24.55	24.43	24.44	5786585.0
2006-07-27 11:30:00	MSFT	Stock	24.44	24.51	24.4	24.47	4583105.0
2006-07-27 12:00:00	MSFT	Stock	24.47	24.5	24.23	24.28	5226183.0
2006-07-27 12:30:00	MSFT	Stock	24.28	24.28	24.11	24.12	4776652.0
2006-07-27 13:00:00	MSFT	Stock	24.12	24.14	24.01	24.03	4780591.0
2006-07-27 13:30:00	MSFT	Stock	24.023	24.03	23.81	23.817	9711904.0
2006-07-27 14:00:00	MSFT	Stock	23.82	24.01	23.77	23.94	8831192.0
2006-07-27 14:30:00	MSFT	Stock	23.95	24.17	23.9	24.13	6445216.0
2006-07-27 15:00:00	MSFT	Stock	24.14	24.16	24.03	24.03	5514086.0
2006-07-27 15:30:00	MSFT	Stock	24.03	24.11	23.85	23.88	10580753.0
2006-07-27 16:00:00	MSFT	Stock	23.9	23.98	23.87	23.98	192408.0
2006-07-27 16:30:00	MSFT	Stock	23.98	23.98	23.93	23.93	3552.0
2006-07-27 17:00:00	MSFT	Stock	23.95	23.95	23.93	23.94	6651.0
2006-07-27 17:30:00	MSFT	Stock	23.95	23.95	23.868	23.94	1062.0
2006-07-27 18:00:00	MSFT	Stock	23.94	23.94	23.92	23.94	2364.0
2006-07-27 08:00:00	NVDA	Stock	0.3417	0.3417	0.3383	0.3383	30000.0
2006-07-27 08:30:00	NVDA	Stock	0.3445	0.3445	0.3445	0.3445	60000.0
2006-07-27 09:00:00	NVDA	Stock	0.3417	0.3438	0.3417	0.3417	270000.0
2006-07-27 09:30:00	NVDA	Stock	0.3418	0.3558	0.3417	0.3483	99687540.0
2006-07-27 10:00:00	NVDA	Stock	0.3483	0.3492	0.3467	0.347	49778700.0
2006-07-27 10:30:00	NVDA	Stock	0.347	0.3483	0.3433	0.3452	42043080.0
2006-07-27 11:00:00	NVDA	Stock	0.3452	0.3492	0.345	0.3472	39027300.0
2006-07-27 11:30:00	NVDA	Stock	0.3473	0.3487	0.3452	0.3461	108522660.0
2006-07-27 12:00:00	NVDA	Stock	0.346	0.3498	0.3452	0.3498	35586120.0

> showing 50 of 50,376 rows — these rows as CSV

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