PREVIEW / stock_30min / 2011-10-05

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-05.parquet
  size:    1.4 MB
  rows:    74,956
  symbols: 3,510

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-10-05 04:30:00	AAPL	Stock	13.2411	13.2554	13.2321	13.2554	16800.0
2011-10-05 05:00:00	AAPL	Stock	13.2321	13.2321	13.1964	13.1964	14000.0
2011-10-05 05:30:00	AAPL	Stock	13.2214	13.2214	13.2143	13.2143	16800.0
2011-10-05 06:00:00	AAPL	Stock	13.2143	13.2321	13.2143	13.2214	52640.0
2011-10-05 06:30:00	AAPL	Stock	13.2321	13.2661	13.2221	13.2607	67200.0
2011-10-05 07:00:00	AAPL	Stock	13.2679	13.3371	13.2679	13.3214	222936.0
2011-10-05 07:30:00	AAPL	Stock	13.3089	13.3089	13.1732	13.1804	444444.0
2011-10-05 08:00:00	AAPL	Stock	13.2143	13.2371	13.0982	13.0982	2866416.0
2011-10-05 08:30:00	AAPL	Stock	13.0982	13.1532	13.0457	13.0964	3634680.0
2011-10-05 09:00:00	AAPL	Stock	13.1011	13.1925	13.1011	13.1379	2475648.0
2011-10-05 09:30:00	AAPL	Stock	13.1386	13.1389	12.8679	12.9939	127260672.0
2011-10-05 10:00:00	AAPL	Stock	12.9912	13.2036	12.9343	13.0968	89504044.0
2011-10-05 10:30:00	AAPL	Stock	13.0968	13.3382	13.0968	13.3089	72054192.0
2011-10-05 11:00:00	AAPL	Stock	13.3089	13.3236	13.1671	13.2361	51863084.0
2011-10-05 11:30:00	AAPL	Stock	13.2389	13.35	13.232	13.3141	42617120.0
2011-10-05 12:00:00	AAPL	Stock	13.3154	13.3382	13.1786	13.1857	39475856.0
2011-10-05 12:30:00	AAPL	Stock	13.1858	13.3286	13.1668	13.3236	36880032.0
2011-10-05 13:00:00	AAPL	Stock	13.3246	13.4232	13.3229	13.4104	53700276.0
2011-10-05 13:30:00	AAPL	Stock	13.4107	13.4929	13.3451	13.4804	40817084.0
2011-10-05 14:00:00	AAPL	Stock	13.4804	13.565	13.4764	13.5475	53850216.0
2011-10-05 14:30:00	AAPL	Stock	13.5454	13.5639	13.4404	13.5293	52847228.0
2011-10-05 15:00:00	AAPL	Stock	13.5318	13.5393	13.4725	13.5089	38893792.0
2011-10-05 15:30:00	AAPL	Stock	13.5104	13.5446	13.4814	13.5221	58983148.0
2011-10-05 16:00:00	AAPL	Stock	13.5214	13.5464	13.0134	13.5089	12244120.0
2011-10-05 16:30:00	AAPL	Stock	13.5196	13.5232	13.0318	13.5179	620928.0
2011-10-05 17:00:00	AAPL	Stock	13.5164	13.5218	13.5093	13.5218	143612.0
2011-10-05 17:30:00	AAPL	Stock	13.5179	13.5238	13.5146	13.5179	120008.0
2011-10-05 18:00:00	AAPL	Stock	13.5204	13.5268	13.5089	13.5193	202272.0
2011-10-05 18:30:00	AAPL	Stock	13.5232	13.5236	13.5146	13.5146	182980.0
2011-10-05 19:00:00	AAPL	Stock	13.5146	13.5204	13.5018	13.5111	81592.0
2011-10-05 19:30:00	AAPL	Stock	13.5179	13.5179	13.4721	13.4721	66640.0
2011-10-05 06:00:00	MSFT	Stock	25.42	25.42	25.42	25.42	200.0
2011-10-05 06:30:00	MSFT	Stock	25.4	25.4	25.4	25.4	200.0
2011-10-05 07:00:00	MSFT	Stock	25.42	25.42	25.42	25.42	100.0
2011-10-05 07:30:00	MSFT	Stock	25.42	25.42	25.32	25.35	600.0
2011-10-05 08:00:00	MSFT	Stock	25.39	25.5	25.34	25.37	31262.0
2011-10-05 08:30:00	MSFT	Stock	25.39	25.44	25.3	25.31	19937.0
2011-10-05 09:00:00	MSFT	Stock	25.32	25.45	25.31	25.4	30865.0
2011-10-05 09:30:00	MSFT	Stock	25.4	25.535	25.16	25.482	6826401.0
2011-10-05 10:00:00	MSFT	Stock	25.48	25.6	25.42	25.505	6847535.0
2011-10-05 10:30:00	MSFT	Stock	25.51	26.03	25.5	26.02	9591253.0
2011-10-05 11:00:00	MSFT	Stock	26.025	26.11	25.91	25.92	7406885.0
2011-10-05 11:30:00	MSFT	Stock	25.915	25.98	25.84	25.935	3446812.0
2011-10-05 12:00:00	MSFT	Stock	25.935	25.99	25.75	25.76	4581661.0
2011-10-05 12:30:00	MSFT	Stock	25.75	25.96	25.73	25.945	3014442.0
2011-10-05 13:00:00	MSFT	Stock	25.945	25.99	25.88	25.965	2394698.0
2011-10-05 13:30:00	MSFT	Stock	25.97	26.11	25.93	26.091	4345505.0
2011-10-05 14:00:00	MSFT	Stock	26.09	26.16	26.0	26.133	3860205.0
2011-10-05 14:30:00	MSFT	Stock	26.135	26.139	25.68	25.7	12806647.0
2011-10-05 15:00:00	MSFT	Stock	25.695	25.78	25.4	25.715	12040866.0

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

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