PREVIEW / stock_30min / 2012-09-10

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-10.parquet
  size:    1.4 MB
  rows:    76,168
  symbols: 3,468

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-10 04:00:00	AAPL	Stock	24.295	24.295	24.295	24.295	5600.0
2012-09-10 04:30:00	AAPL	Stock	24.3	24.3	24.3	24.3	6048.0
2012-09-10 05:00:00	AAPL	Stock	24.3036	24.3036	24.3036	24.3036	2800.0
2012-09-10 05:30:00	AAPL	Stock	24.3236	24.3236	24.3057	24.3057	5600.0
2012-09-10 06:00:00	AAPL	Stock	24.3214	24.3214	24.3054	24.3054	13720.0
2012-09-10 06:30:00	AAPL	Stock	24.3314	24.3321	24.3107	24.3214	37436.0
2012-09-10 07:00:00	AAPL	Stock	24.3179	24.3246	24.2932	24.3143	220444.0
2012-09-10 07:30:00	AAPL	Stock	24.3136	24.3318	24.3107	24.3293	290976.0
2012-09-10 08:00:00	AAPL	Stock	24.3261	24.3514	24.2857	24.2857	1438304.0
2012-09-10 08:30:00	AAPL	Stock	24.2857	24.2961	24.2675	24.2736	748496.0
2012-09-10 09:00:00	AAPL	Stock	24.2714	24.3143	24.2714	24.2929	1037484.0
2012-09-10 09:30:00	AAPL	Stock	24.295	24.4032	24.2368	24.2393	65397892.0
2012-09-10 10:00:00	AAPL	Stock	24.2429	24.2661	24.1536	24.1786	46512564.0
2012-09-10 10:30:00	AAPL	Stock	24.1782	24.1893	23.9868	24.0586	56230832.0
2012-09-10 11:00:00	AAPL	Stock	24.0595	24.1317	24.0407	24.085	28025676.0
2012-09-10 11:30:00	AAPL	Stock	24.0846	24.1182	24.0536	24.1029	15251628.0
2012-09-10 12:00:00	AAPL	Stock	24.1021	24.1071	23.9643	24.0104	26284412.0
2012-09-10 12:30:00	AAPL	Stock	24.0061	24.0354	23.9464	24.0046	22815072.0
2012-09-10 13:00:00	AAPL	Stock	24.0039	24.0464	23.9632	24.0142	17218712.0
2012-09-10 13:30:00	AAPL	Stock	24.0129	24.0243	23.8446	23.8498	30933728.0
2012-09-10 14:00:00	AAPL	Stock	23.8457	23.91	23.8279	23.8696	30085692.0
2012-09-10 14:30:00	AAPL	Stock	23.8696	23.8936	23.7704	23.7718	30636872.0
2012-09-10 15:00:00	AAPL	Stock	23.7736	23.8393	23.7543	23.8171	35172340.0
2012-09-10 15:30:00	AAPL	Stock	23.8143	23.83	23.6464	23.6614	64413608.0
2012-09-10 16:00:00	AAPL	Stock	23.6616	24.0064	23.6143	23.6143	8826412.0
2012-09-10 16:30:00	AAPL	Stock	23.6168	23.8084	23.6	23.6239	1267700.0
2012-09-10 17:00:00	AAPL	Stock	23.6214	23.6693	23.5536	23.5714	1794268.0
2012-09-10 17:30:00	AAPL	Stock	23.5754	23.5889	23.5643	23.565	443940.0
2012-09-10 18:00:00	AAPL	Stock	23.5679	23.5704	23.5504	23.5611	355348.0
2012-09-10 18:30:00	AAPL	Stock	23.5604	23.5843	23.5604	23.5739	305088.0
2012-09-10 19:00:00	AAPL	Stock	23.5786	23.5804	23.5643	23.5714	193928.0
2012-09-10 19:30:00	AAPL	Stock	23.575	23.5839	23.5696	23.5821	286272.0
2012-09-10 08:00:00	MSFT	Stock	30.88	30.94	30.83	30.88	2846.0
2012-09-10 08:30:00	MSFT	Stock	30.83	30.83	30.83	30.83	2000.0
2012-09-10 09:00:00	MSFT	Stock	30.86	30.86	30.79	30.79	9852.0
2012-09-10 09:30:00	MSFT	Stock	30.78	30.85	30.51	30.61	4990536.0
2012-09-10 10:00:00	MSFT	Stock	30.615	30.8	30.59	30.775	4232896.0
2012-09-10 10:30:00	MSFT	Stock	30.775	30.78	30.71	30.755	1601199.0
2012-09-10 11:00:00	MSFT	Stock	30.755	30.9	30.75	30.815	2315160.0
2012-09-10 11:30:00	MSFT	Stock	30.81	30.86	30.8	30.84	1561240.0
2012-09-10 12:00:00	MSFT	Stock	30.84	30.855	30.82	30.84	1450997.0
2012-09-10 12:30:00	MSFT	Stock	30.84	30.85	30.81	30.848	1257635.0
2012-09-10 13:00:00	MSFT	Stock	30.845	30.85	30.8	30.805	1794307.0
2012-09-10 13:30:00	MSFT	Stock	30.805	30.82	30.74	30.74	1709852.0
2012-09-10 14:00:00	MSFT	Stock	30.74	30.78	30.74	30.74	1233290.0
2012-09-10 14:30:00	MSFT	Stock	30.745	30.75	30.65	30.69	2372529.0
2012-09-10 15:00:00	MSFT	Stock	30.69	30.75	30.645	30.739	3141466.0
2012-09-10 15:30:00	MSFT	Stock	30.735	30.76	30.7	30.72	8139911.0
2012-09-10 16:00:00	MSFT	Stock	30.72	30.842	30.7	30.72	2904364.0
2012-09-10 16:30:00	MSFT	Stock	30.72	30.786	30.71	30.71	144401.0

> showing 50 of 76,168 rows — these rows as CSV

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