PREVIEW / stock_30min / 2011-01-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-25.parquet
  size:    1.4 MB
  rows:    75,563
  symbols: 3,528

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
2011-01-25 05:30:00	AAPL	Stock	12.04	12.0446	12.04	12.0446	8400.0
2011-01-25 06:00:00	AAPL	Stock	12.0518	12.0518	12.0429	12.0429	5600.0
2011-01-25 06:30:00	AAPL	Stock	12.0568	12.0568	12.0568	12.0568	2800.0
2011-01-25 07:00:00	AAPL	Stock	12.0625	12.0714	12.0493	12.0571	152964.0
2011-01-25 07:30:00	AAPL	Stock	12.0661	12.0661	12.0232	12.0304	184212.0
2011-01-25 08:00:00	AAPL	Stock	12.0286	12.0479	11.995	12.0093	1208676.0
2011-01-25 08:30:00	AAPL	Stock	12.0093	12.0107	11.9839	12.0014	727468.0
2011-01-25 09:00:00	AAPL	Stock	12.0011	12.0154	11.9864	12.0143	1459976.0
2011-01-25 09:30:00	AAPL	Stock	12.0129	12.0821	11.9489	12.0818	99557948.0
2011-01-25 10:00:00	AAPL	Stock	12.0818	12.1118	12.0532	12.08	57777356.0
2011-01-25 10:30:00	AAPL	Stock	12.0786	12.1564	12.0757	12.1507	48965672.0
2011-01-25 11:00:00	AAPL	Stock	12.1493	12.1604	12.0743	12.0911	52094924.0
2011-01-25 11:30:00	AAPL	Stock	12.0921	12.1054	12.0775	12.0989	25668216.0
2011-01-25 12:00:00	AAPL	Stock	12.0986	12.1571	12.0986	12.1418	31740632.0
2011-01-25 12:30:00	AAPL	Stock	12.142	12.175	12.12	12.1517	21353416.0
2011-01-25 13:00:00	AAPL	Stock	12.1507	12.1518	12.1121	12.125	18385892.0
2011-01-25 13:30:00	AAPL	Stock	12.125	12.1439	12.1143	12.1255	14463652.0
2011-01-25 14:00:00	AAPL	Stock	12.1254	12.1307	12.0679	12.0857	36491448.0
2011-01-25 14:30:00	AAPL	Stock	12.0854	12.1132	12.0818	12.1089	19889744.0
2011-01-25 15:00:00	AAPL	Stock	12.1086	12.1561	12.0982	12.1505	33423796.0
2011-01-25 15:30:00	AAPL	Stock	12.1514	12.1943	12.1404	12.1929	68258036.0
2011-01-25 16:00:00	AAPL	Stock	12.1911	12.2054	12.1019	12.1964	1921528.0
2011-01-25 16:30:00	AAPL	Stock	12.1982	12.1982	12.1596	12.1957	318892.0
2011-01-25 17:00:00	AAPL	Stock	12.1946	12.1996	12.1946	12.1996	185724.0
2011-01-25 17:30:00	AAPL	Stock	12.1993	12.2071	12.1982	12.2071	156828.0
2011-01-25 18:00:00	AAPL	Stock	12.2018	12.205	12.1929	12.2014	2296840.0
2011-01-25 18:30:00	AAPL	Stock	12.2025	12.2082	12.2025	12.205	77588.0
2011-01-25 19:00:00	AAPL	Stock	12.2036	12.2054	12.1964	12.1964	167104.0
2011-01-25 19:30:00	AAPL	Stock	12.1964	12.2014	12.1929	12.2	135408.0
2011-01-25 07:00:00	MSFT	Stock	28.38	28.38	28.37	28.37	200.0
2011-01-25 07:30:00	MSFT	Stock	28.38	28.38	28.38	28.38	300.0
2011-01-25 08:00:00	MSFT	Stock	28.38	28.38	28.24	28.25	21235.0
2011-01-25 08:30:00	MSFT	Stock	28.25	28.25	28.18	28.2	16667.0
2011-01-25 09:00:00	MSFT	Stock	28.24	28.25	28.12	28.12	18105.0
2011-01-25 09:30:00	MSFT	Stock	28.14	28.36	28.12	28.32	4411164.0
2011-01-25 10:00:00	MSFT	Stock	28.31	28.37	28.21	28.34	4030630.0
2011-01-25 10:30:00	MSFT	Stock	28.34	28.4	28.29	28.35	3103998.0
2011-01-25 11:00:00	MSFT	Stock	28.34	28.36	28.18	28.225	3250556.0
2011-01-25 11:30:00	MSFT	Stock	28.22	28.35	28.19	28.291	2249756.0
2011-01-25 12:00:00	MSFT	Stock	28.29	28.422	28.29	28.4	2199569.0
2011-01-25 12:30:00	MSFT	Stock	28.405	28.42	28.35	28.4	2021461.0
2011-01-25 13:00:00	MSFT	Stock	28.395	28.42	28.3	28.31	2723830.0
2011-01-25 13:30:00	MSFT	Stock	28.31	28.38	28.28	28.35	1074162.0
2011-01-25 14:00:00	MSFT	Stock	28.36	28.36	28.19	28.222	2560965.0
2011-01-25 14:30:00	MSFT	Stock	28.221	28.31	28.22	28.29	2248522.0
2011-01-25 15:00:00	MSFT	Stock	28.29	28.4	28.28	28.382	2786025.0
2011-01-25 15:30:00	MSFT	Stock	28.39	28.45	28.325	28.45	4826266.0
2011-01-25 16:00:00	MSFT	Stock	28.45	28.45	28.312	28.45	1453596.0
2011-01-25 16:30:00	MSFT	Stock	28.41	28.447	28.39	28.39	19348.0
2011-01-25 17:30:00	MSFT	Stock	28.37	28.38	28.36	28.38	300.0

> showing 50 of 75,563 rows — these rows as CSV

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