PREVIEW / stock_30min / 2009-01-07

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-07.parquet
  size:    1.3 MB
  rows:    70,776
  symbols: 3,325

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-01-07 07:30:00	AAPL	Stock	3.2875	3.2875	3.2875	3.2875	23800.0
2009-01-07 08:00:00	AAPL	Stock	3.3	3.3007	3.2704	3.2786	982100.0
2009-01-07 08:30:00	AAPL	Stock	3.2789	3.3036	3.2779	3.2904	1259972.0
2009-01-07 09:00:00	AAPL	Stock	3.2879	3.2879	3.2714	3.2786	2350040.0
2009-01-07 09:30:00	AAPL	Stock	3.2786	3.295	3.2386	3.29	120245776.0
2009-01-07 10:00:00	AAPL	Stock	3.2904	3.2979	3.2329	3.2464	77047852.0
2009-01-07 10:30:00	AAPL	Stock	3.2457	3.2761	3.2321	3.2721	53686416.0
2009-01-07 11:00:00	AAPL	Stock	3.2721	3.285	3.2661	3.2707	42847364.0
2009-01-07 11:30:00	AAPL	Stock	3.2704	3.2911	3.2596	3.2739	37921800.0
2009-01-07 12:00:00	AAPL	Stock	3.2743	3.285	3.2661	3.2832	28086520.0
2009-01-07 12:30:00	AAPL	Stock	3.2839	3.3036	3.2771	3.2857	40447484.0
2009-01-07 13:00:00	AAPL	Stock	3.2864	3.2907	3.2689	3.27	38761520.0
2009-01-07 13:30:00	AAPL	Stock	3.2696	3.28	3.2454	3.2471	41694100.0
2009-01-07 14:00:00	AAPL	Stock	3.2468	3.2596	3.23	3.2386	55366024.0
2009-01-07 14:30:00	AAPL	Stock	3.2389	3.2496	3.2275	3.2425	39554956.0
2009-01-07 15:00:00	AAPL	Stock	3.2421	3.2496	3.2236	3.2457	59690652.0
2009-01-07 15:30:00	AAPL	Stock	3.2457	3.25	3.2296	3.25	74702908.0
2009-01-07 16:00:00	AAPL	Stock	3.25	3.2594	3.2385	3.2504	20556592.0
2009-01-07 16:30:00	AAPL	Stock	3.2511	3.2536	3.2375	3.2536	739676.0
2009-01-07 17:00:00	AAPL	Stock	3.2532	3.2536	3.25	3.2536	11014836.0
2009-01-07 17:30:00	AAPL	Stock	3.2507	3.2536	3.2507	3.2507	61404.0
2009-01-07 18:00:00	AAPL	Stock	3.2507	3.2507	3.2493	3.25	3776612.0
2009-01-07 18:30:00	AAPL	Stock	3.2489	3.2496	3.2464	3.2464	249200.0
2009-01-07 19:00:00	AAPL	Stock	3.2464	3.2536	3.2464	3.2536	73444.0
2009-01-07 19:30:00	AAPL	Stock	3.2557	3.2564	3.2536	3.2564	100548.0
2009-01-07 08:00:00	MSFT	Stock	20.56	20.56	20.5	20.5	4462.0
2009-01-07 08:30:00	MSFT	Stock	20.5	20.5	20.39	20.44	10366.0
2009-01-07 09:00:00	MSFT	Stock	20.44	20.44	20.1	20.19	102828.0
2009-01-07 09:30:00	MSFT	Stock	20.19	20.29	19.98	20.151	7179057.0
2009-01-07 10:00:00	MSFT	Stock	20.158	20.229	20.0	20.07	4233295.0
2009-01-07 10:30:00	MSFT	Stock	20.07	20.25	20.05	20.23	3074175.0
2009-01-07 11:00:00	MSFT	Stock	20.23	20.29	20.12	20.148	2421423.0
2009-01-07 11:30:00	MSFT	Stock	20.141	20.26	20.14	20.15	3386468.0
2009-01-07 12:00:00	MSFT	Stock	20.15	20.182	20.1	20.15	2548989.0
2009-01-07 12:30:00	MSFT	Stock	20.159	20.16	20.06	20.08	2157526.0
2009-01-07 13:00:00	MSFT	Stock	20.07	20.15	20.06	20.14	2015863.0
2009-01-07 13:30:00	MSFT	Stock	20.14	20.17	19.74	19.78	5184191.0
2009-01-07 14:00:00	MSFT	Stock	19.78	19.83	19.65	19.71	5012112.0
2009-01-07 14:30:00	MSFT	Stock	19.7	19.77	19.63	19.695	5950319.0
2009-01-07 15:00:00	MSFT	Stock	19.7	19.7	19.48	19.67	8925171.0
2009-01-07 15:30:00	MSFT	Stock	19.67	19.7	19.48	19.505	13450758.0
2009-01-07 16:00:00	MSFT	Stock	19.51	19.882	19.49	19.54	6011045.0
2009-01-07 16:30:00	MSFT	Stock	19.53	19.702	19.51	19.6	34029.0
2009-01-07 17:00:00	MSFT	Stock	19.51	20.802	19.51	19.6	553519.0
2009-01-07 17:30:00	MSFT	Stock	19.6	19.61	19.59	19.6	1997.0
2009-01-07 18:00:00	MSFT	Stock	19.6	19.6	19.59	19.6	7762.0
2009-01-07 18:30:00	MSFT	Stock	19.6	19.64	19.6	19.64	7510.0
2009-01-07 19:00:00	MSFT	Stock	19.63	19.64	19.61	19.61	19780.0
2009-01-07 19:30:00	MSFT	Stock	19.61	19.65	19.61	19.63	4023.0
2009-01-07 04:00:00	NVDA	Stock	0.2325	0.2325	0.2325	0.2325	8000.0

> showing 50 of 70,776 rows — these rows as CSV

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