PREVIEW / stock_30min / 2010-02-25

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-25.parquet
  size:    1.4 MB
  rows:    74,234
  symbols: 3,439

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
2010-02-25 04:00:00	AAPL	Stock	7.1254	7.1254	7.1254	7.1254	2800.0
2010-02-25 04:30:00	AAPL	Stock	7.1361	7.1361	7.1361	7.1361	2800.0
2010-02-25 06:30:00	AAPL	Stock	7.1339	7.1339	7.1339	7.1339	5600.0
2010-02-25 07:00:00	AAPL	Stock	7.1346	7.1364	7.1329	7.1329	24640.0
2010-02-25 07:30:00	AAPL	Stock	7.1271	7.1286	7.1246	7.125	35728.0
2010-02-25 08:00:00	AAPL	Stock	7.125	7.1364	7.1182	7.1296	861980.0
2010-02-25 08:30:00	AAPL	Stock	7.1271	7.1307	7.0996	7.1036	1587600.0
2010-02-25 09:00:00	AAPL	Stock	7.105	7.105	7.0464	7.0486	3836728.0
2010-02-25 09:30:00	AAPL	Stock	7.0486	7.0768	7.0318	7.0611	80329116.0
2010-02-25 10:00:00	AAPL	Stock	7.0614	7.0893	7.0471	7.0679	51909368.0
2010-02-25 10:30:00	AAPL	Stock	7.0686	7.0761	7.0496	7.0628	31730020.0
2010-02-25 11:00:00	AAPL	Stock	7.0614	7.0804	7.0571	7.0675	21515256.0
2010-02-25 11:30:00	AAPL	Stock	7.0671	7.0714	7.0468	7.0521	24457328.0
2010-02-25 12:00:00	AAPL	Stock	7.0514	7.0689	7.0479	7.0607	16085552.0
2010-02-25 12:30:00	AAPL	Stock	7.0604	7.0807	7.0571	7.07	19185488.0
2010-02-25 13:00:00	AAPL	Stock	7.0714	7.0779	7.0571	7.0629	13056904.0
2010-02-25 13:30:00	AAPL	Stock	7.0639	7.125	7.0618	7.125	38020192.0
2010-02-25 14:00:00	AAPL	Stock	7.125	7.1743	7.125	7.1454	130886672.0
2010-02-25 14:30:00	AAPL	Stock	7.1454	7.1696	7.1336	7.1614	53401880.0
2010-02-25 15:00:00	AAPL	Stock	7.1614	7.1964	7.1614	7.1945	58904468.0
2010-02-25 15:30:00	AAPL	Stock	7.1943	7.245	7.1893	7.2143	110018468.0
2010-02-25 16:00:00	AAPL	Stock	7.2161	7.2242	7.0645	7.2136	4680172.0
2010-02-25 16:30:00	AAPL	Stock	7.1937	7.2146	7.1937	7.2107	525756.0
2010-02-25 17:00:00	AAPL	Stock	7.2118	7.2129	7.2057	7.2061	206696.0
2010-02-25 17:30:00	AAPL	Stock	7.2071	7.2071	7.2007	7.2007	163100.0
2010-02-25 18:00:00	AAPL	Stock	7.2014	7.2143	7.2014	7.2071	143640.0
2010-02-25 18:30:00	AAPL	Stock	7.2071	7.2071	7.2021	7.2061	53200.0
2010-02-25 19:00:00	AAPL	Stock	7.2061	7.2064	7.2046	7.205	64680.0
2010-02-25 19:30:00	AAPL	Stock	7.205	7.2143	7.205	7.2121	153020.0
2010-02-25 07:30:00	MSFT	Stock	28.52	28.52	28.51	28.51	2000.0
2010-02-25 08:00:00	MSFT	Stock	28.52	28.52	28.47	28.48	12690.0
2010-02-25 08:30:00	MSFT	Stock	28.46	28.46	28.4	28.41	26643.0
2010-02-25 09:00:00	MSFT	Stock	28.4	28.41	28.2	28.2	103556.0
2010-02-25 09:30:00	MSFT	Stock	28.2	28.29	28.02	28.085	5470475.0
2010-02-25 10:00:00	MSFT	Stock	28.088	28.22	28.03	28.17	5033290.0
2010-02-25 10:30:00	MSFT	Stock	28.17	28.21	28.12	28.15	3492049.0
2010-02-25 11:00:00	MSFT	Stock	28.141	28.17	28.09	28.13	2501909.0
2010-02-25 11:30:00	MSFT	Stock	28.13	28.17	28.09	28.15	2747816.0
2010-02-25 12:00:00	MSFT	Stock	28.15	28.3	28.14	28.275	3037424.0
2010-02-25 12:30:00	MSFT	Stock	28.271	28.33	28.21	28.275	3432026.0
2010-02-25 13:00:00	MSFT	Stock	28.28	28.29	28.18	28.2	1426412.0
2010-02-25 13:30:00	MSFT	Stock	28.2	28.52	28.19	28.505	3123643.0
2010-02-25 14:00:00	MSFT	Stock	28.52	28.6	28.45	28.47	3993769.0
2010-02-25 14:30:00	MSFT	Stock	28.467	28.53	28.42	28.5	1926889.0
2010-02-25 15:00:00	MSFT	Stock	28.5	28.63	28.45	28.58	3177497.0
2010-02-25 15:30:00	MSFT	Stock	28.58	28.65	28.52	28.6	5088541.0
2010-02-25 16:00:00	MSFT	Stock	28.61	28.61	28.097	28.58	1717758.0
2010-02-25 16:30:00	MSFT	Stock	28.575	28.6	28.177	28.56	128564.0
2010-02-25 17:00:00	MSFT	Stock	28.56	28.63	28.52	28.63	700200.0
2010-02-25 18:00:00	MSFT	Stock	28.52	28.52	28.52	28.52	300.0

> showing 50 of 74,234 rows — these rows as CSV

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