PREVIEW / stock_30min / 2012-09-28

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-28.parquet
  size:    1.4 MB
  rows:    74,466
  symbols: 3,505

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-28 04:00:00	AAPL	Stock	24.4104	24.4104	24.4	24.4	28000.0
2012-09-28 04:30:00	AAPL	Stock	24.4286	24.4286	24.4196	24.4286	9352.0
2012-09-28 05:00:00	AAPL	Stock	24.4411	24.4411	24.4411	24.4411	5600.0
2012-09-28 05:30:00	AAPL	Stock	24.4286	24.4286	24.4107	24.4107	70000.0
2012-09-28 06:00:00	AAPL	Stock	24.4107	24.4107	24.3571	24.3571	70392.0
2012-09-28 06:30:00	AAPL	Stock	24.3571	24.3571	24.3236	24.3521	23828.0
2012-09-28 07:00:00	AAPL	Stock	24.3521	24.3521	24.245	24.2768	405132.0
2012-09-28 07:30:00	AAPL	Stock	24.2857	24.2946	24.25	24.2946	148204.0
2012-09-28 08:00:00	AAPL	Stock	24.2882	24.3214	24.2068	24.2068	1877820.0
2012-09-28 08:30:00	AAPL	Stock	24.2239	24.2411	24.175	24.2382	1791972.0
2012-09-28 09:00:00	AAPL	Stock	24.2425	24.2571	24.2018	24.2357	1781836.0
2012-09-28 09:30:00	AAPL	Stock	24.2407	24.3254	24.0989	24.1346	87104052.0
2012-09-28 10:00:00	AAPL	Stock	24.1289	24.2121	23.9582	23.9796	54409572.0
2012-09-28 10:30:00	AAPL	Stock	23.9841	24.0893	23.979	24.0457	39709208.0
2012-09-28 11:00:00	AAPL	Stock	24.0457	24.0511	23.8857	23.8909	33354076.0
2012-09-28 11:30:00	AAPL	Stock	23.8907	23.9989	23.8125	23.9857	45365236.0
2012-09-28 12:00:00	AAPL	Stock	23.9852	24.1032	23.955	24.0007	37969120.0
2012-09-28 12:30:00	AAPL	Stock	23.9993	24.0671	23.955	24.0636	16834188.0
2012-09-28 13:00:00	AAPL	Stock	24.0609	24.0861	23.9646	24.0411	16567040.0
2012-09-28 13:30:00	AAPL	Stock	24.0457	24.1229	24.02	24.0329	23718072.0
2012-09-28 14:00:00	AAPL	Stock	24.0311	24.0618	23.9107	23.9379	24774484.0
2012-09-28 14:30:00	AAPL	Stock	23.9404	23.9714	23.8779	23.945	27039376.0
2012-09-28 15:00:00	AAPL	Stock	23.9407	23.9682	23.9086	23.9207	21409332.0
2012-09-28 15:30:00	AAPL	Stock	23.9165	23.9286	23.8225	23.8243	66666964.0
2012-09-28 16:00:00	AAPL	Stock	23.8243	24.19	23.8171	23.825	18549412.0
2012-09-28 16:30:00	AAPL	Stock	23.8232	24.0122	23.815	23.8271	942144.0
2012-09-28 17:00:00	AAPL	Stock	23.8271	23.8271	23.7943	23.8057	398132.0
2012-09-28 17:30:00	AAPL	Stock	23.8025	24.0282	23.7929	23.8011	129500.0
2012-09-28 18:00:00	AAPL	Stock	23.8007	23.8018	23.7896	23.7993	146804.0
2012-09-28 18:30:00	AAPL	Stock	23.7989	23.8018	23.7786	23.7786	241556.0
2012-09-28 19:00:00	AAPL	Stock	23.7882	23.7975	23.7857	23.7861	88060.0
2012-09-28 19:30:00	AAPL	Stock	23.7857	23.7857	23.7714	23.7771	219296.0
2012-09-28 08:00:00	MSFT	Stock	30.23	30.23	30.04	30.04	4599.0
2012-09-28 08:30:00	MSFT	Stock	30.04	30.04	30.0	30.02	24350.0
2012-09-28 09:00:00	MSFT	Stock	30.07	30.23	30.03	30.16	64954.0
2012-09-28 09:30:00	MSFT	Stock	30.18	30.26	29.94	29.95	5778706.0
2012-09-28 10:00:00	MSFT	Stock	29.95	30.05	29.88	29.89	5310896.0
2012-09-28 10:30:00	MSFT	Stock	29.885	29.92	29.79	29.845	4545801.0
2012-09-28 11:00:00	MSFT	Stock	29.845	29.91	29.82	29.82	3243668.0
2012-09-28 11:30:00	MSFT	Stock	29.82	29.86	29.76	29.77	2279250.0
2012-09-28 12:00:00	MSFT	Stock	29.77	29.91	29.75	29.835	2945207.0
2012-09-28 12:30:00	MSFT	Stock	29.84	29.86	29.82	29.82	1151633.0
2012-09-28 13:00:00	MSFT	Stock	29.825	29.88	29.81	29.87	2213755.0
2012-09-28 13:30:00	MSFT	Stock	29.865	29.98	29.865	29.928	2646092.0
2012-09-28 14:00:00	MSFT	Stock	29.93	29.98	29.81	29.835	3802850.0
2012-09-28 14:30:00	MSFT	Stock	29.84	29.87	29.79	29.855	2045371.0
2012-09-28 15:00:00	MSFT	Stock	29.85	29.87	29.79	29.801	2058834.0
2012-09-28 15:30:00	MSFT	Stock	29.805	29.88	29.74	29.75	7998110.0
2012-09-28 16:00:00	MSFT	Stock	29.755	30.15	29.75	29.76	5856423.0
2012-09-28 16:30:00	MSFT	Stock	29.76	29.81	29.76	29.76	115648.0

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

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