PREVIEW / stock_30min / 2009-04-16

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-16.parquet
  size:    1.3 MB
  rows:    69,432
  symbols: 3,344

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-04-16 07:30:00	AAPL	Stock	4.1961	4.1961	4.1961	4.1961	5600.0
2009-04-16 08:00:00	AAPL	Stock	4.1961	4.2143	4.1893	4.2125	311080.0
2009-04-16 08:30:00	AAPL	Stock	4.2136	4.2461	4.2107	4.2361	470596.0
2009-04-16 09:00:00	AAPL	Stock	4.2361	4.2625	4.2014	4.2571	8014384.0
2009-04-16 09:30:00	AAPL	Stock	4.2564	4.275	4.2425	4.2741	63649880.0
2009-04-16 10:00:00	AAPL	Stock	4.2746	4.3025	4.2668	4.2992	49523516.0
2009-04-16 10:30:00	AAPL	Stock	4.2989	4.3168	4.2575	4.2689	46228728.0
2009-04-16 11:00:00	AAPL	Stock	4.2689	4.2968	4.2689	4.2964	29198148.0
2009-04-16 11:30:00	AAPL	Stock	4.2954	4.3204	4.2886	4.3011	35578452.0
2009-04-16 12:00:00	AAPL	Stock	4.3018	4.3214	4.2979	4.3132	19321624.0
2009-04-16 12:30:00	AAPL	Stock	4.3132	4.3382	4.3129	4.3314	31110184.0
2009-04-16 13:00:00	AAPL	Stock	4.3314	4.355	4.3304	4.3518	29286152.0
2009-04-16 13:30:00	AAPL	Stock	4.3518	4.3536	4.3318	4.3504	29044512.0
2009-04-16 14:00:00	AAPL	Stock	4.3504	4.3661	4.3461	4.3636	34356028.0
2009-04-16 14:30:00	AAPL	Stock	4.3636	4.3982	4.3593	4.3879	48819008.0
2009-04-16 15:00:00	AAPL	Stock	4.3879	4.3893	4.3611	4.3685	63042140.0
2009-04-16 15:30:00	AAPL	Stock	4.3689	4.385	4.3318	4.3411	79016868.0
2009-04-16 16:00:00	AAPL	Stock	4.3368	4.3946	4.2714	4.3521	20878144.0
2009-04-16 16:30:00	AAPL	Stock	4.3561	4.3632	4.3307	4.3307	664832.0
2009-04-16 17:00:00	AAPL	Stock	4.3318	4.3318	4.2971	4.3104	1066744.0
2009-04-16 17:30:00	AAPL	Stock	4.3161	4.3214	4.3104	4.3214	134624.0
2009-04-16 18:00:00	AAPL	Stock	4.325	4.3257	4.3157	4.325	54600.0
2009-04-16 18:30:00	AAPL	Stock	4.3164	4.3246	4.3164	4.3214	19600.0
2009-04-16 19:00:00	AAPL	Stock	4.3214	4.325	4.3211	4.325	14224.0
2009-04-16 19:30:00	AAPL	Stock	4.3214	4.3286	4.3214	4.3286	64288.0
2009-04-16 07:30:00	MSFT	Stock	18.8	18.82	18.8	18.82	300.0
2009-04-16 08:00:00	MSFT	Stock	18.85	19.0	18.85	19.0	3652.0
2009-04-16 08:30:00	MSFT	Stock	19.03	19.08	19.0	19.08	103765.0
2009-04-16 09:00:00	MSFT	Stock	19.07	19.2	19.07	19.16	187044.0
2009-04-16 09:30:00	MSFT	Stock	19.17	19.3	18.99	19.29	5738223.0
2009-04-16 10:00:00	MSFT	Stock	19.3	19.34	19.15	19.22	4278235.0
2009-04-16 10:30:00	MSFT	Stock	19.21	19.23	19.02	19.06	3946817.0
2009-04-16 11:00:00	MSFT	Stock	19.06	19.17	19.06	19.15	2427658.0
2009-04-16 11:30:00	MSFT	Stock	19.14	19.23	19.13	19.2	2961898.0
2009-04-16 12:00:00	MSFT	Stock	19.2	19.23	19.12	19.12	3702946.0
2009-04-16 12:30:00	MSFT	Stock	19.122	19.23	19.1	19.192	1436368.0
2009-04-16 13:00:00	MSFT	Stock	19.19	19.3	19.19	19.3	3123470.0
2009-04-16 13:30:00	MSFT	Stock	19.295	19.3	19.15	19.26	2468511.0
2009-04-16 14:00:00	MSFT	Stock	19.268	19.45	19.252	19.41	4006394.0
2009-04-16 14:30:00	MSFT	Stock	19.409	19.78	19.4	19.649	8151315.0
2009-04-16 15:00:00	MSFT	Stock	19.64	19.77	19.59	19.69	6894445.0
2009-04-16 15:30:00	MSFT	Stock	19.69	19.78	19.63	19.75	13994277.0
2009-04-16 16:00:00	MSFT	Stock	19.75	19.78	19.3	19.7	3062106.0
2009-04-16 16:30:00	MSFT	Stock	19.436	19.76	19.436	19.6	148293.0
2009-04-16 17:00:00	MSFT	Stock	19.6	19.74	19.56	19.6	10864.0
2009-04-16 17:30:00	MSFT	Stock	19.6	19.65	19.56	19.57	8082.0
2009-04-16 18:30:00	MSFT	Stock	19.58	19.65	19.58	19.65	370.0
2009-04-16 19:30:00	MSFT	Stock	19.58	19.65	19.58	19.65	2937.0
2009-04-16 08:00:00	NVDA	Stock	0.287	0.2875	0.287	0.2875	72000.0
2009-04-16 08:30:00	NVDA	Stock	0.2875	0.289	0.2875	0.289	38600.0

> showing 50 of 69,432 rows — these rows as CSV

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