PREVIEW / stock_30min / 2012-09-18

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-18.parquet
  size:    1.4 MB
  rows:    74,913
  symbols: 3,480

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
2012-09-18 04:00:00	AAPL	Stock	25.0286	25.0286	25.0286	25.0286	8400.0
2012-09-18 04:30:00	AAPL	Stock	25.0607	25.0607	25.0607	25.0607	19600.0
2012-09-18 05:00:00	AAPL	Stock	25.0607	25.0643	25.0607	25.0643	27860.0
2012-09-18 05:30:00	AAPL	Stock	25.0536	25.0536	25.0268	25.0268	14364.0
2012-09-18 06:00:00	AAPL	Stock	25.0271	25.0357	25.0268	25.0357	34860.0
2012-09-18 06:30:00	AAPL	Stock	25.0275	25.0521	25.0275	25.0521	8400.0
2012-09-18 07:00:00	AAPL	Stock	25.0586	25.1	25.0357	25.0446	780500.0
2012-09-18 07:30:00	AAPL	Stock	25.0554	25.0893	25.045	25.0893	596904.0
2012-09-18 08:00:00	AAPL	Stock	25.0893	25.0893	24.9286	24.9596	3194884.0
2012-09-18 08:30:00	AAPL	Stock	24.9464	25.0175	24.9446	24.9971	1536612.0
2012-09-18 09:00:00	AAPL	Stock	24.9929	25.0175	24.9807	24.9954	2672628.0
2012-09-18 09:30:00	AAPL	Stock	24.9961	25.0154	24.8721	25.0125	80746372.0
2012-09-18 10:00:00	AAPL	Stock	25.0093	25.0514	24.9371	24.9971	52316852.0
2012-09-18 10:30:00	AAPL	Stock	24.9971	25.0389	24.9821	24.9959	29947904.0
2012-09-18 11:00:00	AAPL	Stock	24.9929	25.0286	24.9775	24.9954	19825316.0
2012-09-18 11:30:00	AAPL	Stock	24.9954	25.0	24.9814	24.9882	12856480.0
2012-09-18 12:00:00	AAPL	Stock	24.9871	24.9954	24.9182	24.9461	19272484.0
2012-09-18 12:30:00	AAPL	Stock	24.9456	24.9796	24.9416	24.9589	11437132.0
2012-09-18 13:00:00	AAPL	Stock	24.9593	24.9821	24.9411	24.9743	7363496.0
2012-09-18 13:30:00	AAPL	Stock	24.9743	24.9761	24.9375	24.9414	8543780.0
2012-09-18 14:00:00	AAPL	Stock	24.9418	25.0229	24.9411	25.0059	23598204.0
2012-09-18 14:30:00	AAPL	Stock	25.0065	25.0264	24.9893	25.015	13235992.0
2012-09-18 15:00:00	AAPL	Stock	25.0125	25.0354	25.0046	25.0286	21300384.0
2012-09-18 15:30:00	AAPL	Stock	25.0275	25.0832	25.0243	25.0697	49108444.0
2012-09-18 16:00:00	AAPL	Stock	25.0696	25.0786	24.9909	25.0696	6297340.0
2012-09-18 16:30:00	AAPL	Stock	25.0629	25.0679	24.9787	25.0625	1222340.0
2012-09-18 17:00:00	AAPL	Stock	25.0696	25.0696	25.055	25.0571	289016.0
2012-09-18 17:30:00	AAPL	Stock	25.0571	25.0611	25.0446	25.0446	210364.0
2012-09-18 18:00:00	AAPL	Stock	25.0429	25.0511	25.0357	25.0482	275968.0
2012-09-18 18:30:00	AAPL	Stock	25.0361	25.0525	25.0361	25.0489	58660.0
2012-09-18 19:00:00	AAPL	Stock	25.0489	25.05	25.0393	25.0393	74760.0
2012-09-18 19:30:00	AAPL	Stock	25.0382	25.0461	25.0357	25.0375	325500.0
2012-09-18 04:00:00	MSFT	Stock	31.53	31.53	31.53	31.53	172.0
2012-09-18 06:00:00	MSFT	Stock	31.22	31.3	31.22	31.3	3962.0
2012-09-18 07:00:00	MSFT	Stock	31.2	31.2	31.2	31.2	100.0
2012-09-18 07:30:00	MSFT	Stock	31.15	31.15	31.14	31.14	450.0
2012-09-18 08:00:00	MSFT	Stock	31.13	31.13	31.13	31.13	800.0
2012-09-18 08:30:00	MSFT	Stock	31.15	31.15	31.15	31.15	3000.0
2012-09-18 09:00:00	MSFT	Stock	31.15	31.15	31.08	31.12	20488.0
2012-09-18 09:30:00	MSFT	Stock	31.1	31.21	31.03	31.16	4345647.0
2012-09-18 10:00:00	MSFT	Stock	31.16	31.17	31.08	31.12	2697971.0
2012-09-18 10:30:00	MSFT	Stock	31.12	31.18	31.09	31.17	2365912.0
2012-09-18 11:00:00	MSFT	Stock	31.17	31.2	31.16	31.17	1528123.0
2012-09-18 11:30:00	MSFT	Stock	31.17	31.18	31.11	31.15	1810188.0
2012-09-18 12:00:00	MSFT	Stock	31.15	31.18	31.13	31.158	1334940.0
2012-09-18 12:30:00	MSFT	Stock	31.15	31.2	31.15	31.175	902158.0
2012-09-18 13:00:00	MSFT	Stock	31.18	31.21	31.15	31.185	1075840.0
2012-09-18 13:30:00	MSFT	Stock	31.185	31.2	31.17	31.173	1004854.0
2012-09-18 14:00:00	MSFT	Stock	31.175	31.2	31.17	31.18	1023475.0
2012-09-18 14:30:00	MSFT	Stock	31.18	31.2	31.16	31.17	1568342.0

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

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