PREVIEW / stock_30min / 2006-03-20

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-03-20.parquet
  size:    920 KB
  rows:    49,280
  symbols: 2,216

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-20 05:00:00	AAPL	Stock	2.3214	2.3214	2.3214	2.3214	16408.0
2006-03-20 06:30:00	AAPL	Stock	2.3214	2.3214	2.3214	2.3214	176400.0
2006-03-20 07:00:00	AAPL	Stock	2.325	2.3286	2.325	2.3286	56000.0
2006-03-20 07:30:00	AAPL	Stock	2.33	2.3304	2.3232	2.3232	64400.0
2006-03-20 08:00:00	AAPL	Stock	2.3214	2.33	2.3214	2.325	1923096.0
2006-03-20 08:30:00	AAPL	Stock	2.3232	2.3264	2.3218	2.3246	1058988.0
2006-03-20 09:00:00	AAPL	Stock	2.3246	2.3325	2.32	2.3289	4103204.0
2006-03-20 09:30:00	AAPL	Stock	2.3293	2.3379	2.3154	2.3154	113579256.0
2006-03-20 10:00:00	AAPL	Stock	2.3154	2.3196	2.3082	2.3121	63386008.0
2006-03-20 10:30:00	AAPL	Stock	2.3125	2.3154	2.2871	2.295	67464796.0
2006-03-20 11:00:00	AAPL	Stock	2.295	2.3282	2.2946	2.3057	40692176.0
2006-03-20 11:30:00	AAPL	Stock	2.3064	2.3139	2.3004	2.3039	31909080.0
2006-03-20 12:00:00	AAPL	Stock	2.3043	2.3089	2.3011	2.3032	15866508.0
2006-03-20 12:30:00	AAPL	Stock	2.3036	2.31	2.3029	2.3039	20551776.0
2006-03-20 13:00:00	AAPL	Stock	2.3036	2.3043	2.2929	2.2961	29894732.0
2006-03-20 13:30:00	AAPL	Stock	2.2961	2.3287	2.2857	2.2921	31487820.0
2006-03-20 14:00:00	AAPL	Stock	2.2921	2.2982	2.2879	2.2929	30455292.0
2006-03-20 14:30:00	AAPL	Stock	2.2929	2.2932	2.2821	2.2832	37916228.0
2006-03-20 15:00:00	AAPL	Stock	2.2829	2.2904	2.2811	2.2829	43141140.0
2006-03-20 15:30:00	AAPL	Stock	2.2829	2.2918	2.2818	2.2857	60238724.0
2006-03-20 16:00:00	AAPL	Stock	2.2857	2.2871	2.2839	2.2843	1740816.0
2006-03-20 16:30:00	AAPL	Stock	2.2854	2.2854	2.2839	2.2846	431256.0
2006-03-20 17:00:00	AAPL	Stock	2.2839	2.2854	2.2839	2.2854	4812304.0
2006-03-20 17:30:00	AAPL	Stock	2.2857	2.2857	2.2839	2.2839	219296.0
2006-03-20 18:00:00	AAPL	Stock	2.2836	2.2839	2.2832	2.2832	135800.0
2006-03-20 07:00:00	MSFT	Stock	27.59	27.64	27.59	27.64	9240.0
2006-03-20 07:30:00	MSFT	Stock	27.6	27.6	27.55	27.56	9100.0
2006-03-20 08:00:00	MSFT	Stock	27.6	27.63	27.58	27.63	51764.0
2006-03-20 08:30:00	MSFT	Stock	27.63	27.67	27.63	27.67	45533.0
2006-03-20 09:00:00	MSFT	Stock	27.66	27.7	27.64	27.7	160660.0
2006-03-20 09:30:00	MSFT	Stock	27.7	27.79	27.67	27.73	9302422.0
2006-03-20 10:00:00	MSFT	Stock	27.74	27.86	27.71	27.81	7594157.0
2006-03-20 10:30:00	MSFT	Stock	27.8	27.93	27.8	27.9	8133103.0
2006-03-20 11:00:00	MSFT	Stock	27.91	27.97	27.87	27.95	4995885.0
2006-03-20 11:30:00	MSFT	Stock	27.94	27.97	27.91	27.94	4073536.0
2006-03-20 12:00:00	MSFT	Stock	27.95	27.96	27.87	27.93	4220232.0
2006-03-20 12:30:00	MSFT	Stock	27.94	27.99	27.93	27.98	3425487.0
2006-03-20 13:00:00	MSFT	Stock	27.98	27.99	27.94	27.97	2654374.0
2006-03-20 13:30:00	MSFT	Stock	27.97	27.97	27.93	27.93	3515048.0
2006-03-20 14:00:00	MSFT	Stock	27.94	27.95	27.89	27.92	2947366.0
2006-03-20 14:30:00	MSFT	Stock	27.92	27.92	27.87	27.9	3255990.0
2006-03-20 15:00:00	MSFT	Stock	27.9	27.91	27.86	27.88	4307671.0
2006-03-20 15:30:00	MSFT	Stock	27.88	27.91	27.88	27.89	6947410.0
2006-03-20 16:00:00	MSFT	Stock	27.89	27.89	27.8	27.86	317748.0
2006-03-20 16:30:00	MSFT	Stock	27.87	27.88	27.85	27.86	56831.0
2006-03-20 17:00:00	MSFT	Stock	27.85	27.85	27.84	27.84	8446.0
2006-03-20 17:30:00	MSFT	Stock	27.84	27.86	27.84	27.85	800.0
2006-03-20 18:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	964.0
2006-03-20 08:00:00	NVDA	Stock	0.4072	0.4089	0.4072	0.4089	36000.0
2006-03-20 08:30:00	NVDA	Stock	0.4097	0.41	0.4097	0.41	120000.0

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

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