PREVIEW / stock_30min / 2010-02-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-23.parquet
  size:    1.4 MB
  rows:    74,913
  symbols: 3,457

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
2010-02-23 04:30:00	AAPL	Stock	7.1764	7.1764	7.1764	7.1764	2800.0
2010-02-23 05:30:00	AAPL	Stock	7.1621	7.1621	7.1611	7.1611	5740.0
2010-02-23 06:00:00	AAPL	Stock	7.1411	7.1411	7.1411	7.1411	4032.0
2010-02-23 06:30:00	AAPL	Stock	7.1254	7.1254	7.1254	7.1254	5600.0
2010-02-23 07:00:00	AAPL	Stock	7.125	7.1336	7.125	7.1336	17220.0
2010-02-23 07:30:00	AAPL	Stock	7.1321	7.1321	7.1286	7.1304	22400.0
2010-02-23 08:00:00	AAPL	Stock	7.1304	7.15	7.1304	7.1429	352240.0
2010-02-23 08:30:00	AAPL	Stock	7.1375	7.1411	7.1268	7.1336	510020.0
2010-02-23 09:00:00	AAPL	Stock	7.1332	7.1429	7.1307	7.1396	221760.0
2010-02-23 09:30:00	AAPL	Stock	7.1404	7.1904	7.0957	7.1814	64922088.0
2010-02-23 10:00:00	AAPL	Stock	7.1707	7.1836	7.0761	7.0893	78498588.0
2010-02-23 10:30:00	AAPL	Stock	7.0893	7.0914	7.06	7.0879	37958116.0
2010-02-23 11:00:00	AAPL	Stock	7.0864	7.0925	7.0564	7.0586	26456724.0
2010-02-23 11:30:00	AAPL	Stock	7.0571	7.075	7.0471	7.0589	22368332.0
2010-02-23 12:00:00	AAPL	Stock	7.0593	7.0625	6.9896	7.0068	54414080.0
2010-02-23 12:30:00	AAPL	Stock	7.0068	7.0286	7.0054	7.0272	30593808.0
2010-02-23 13:00:00	AAPL	Stock	7.0271	7.0421	7.0136	7.0414	21941024.0
2010-02-23 13:30:00	AAPL	Stock	7.0411	7.0421	7.0214	7.0279	21858032.0
2010-02-23 14:00:00	AAPL	Stock	7.0289	7.0489	7.0189	7.0317	21350868.0
2010-02-23 14:30:00	AAPL	Stock	7.0307	7.0557	7.0229	7.0457	25621344.0
2010-02-23 15:00:00	AAPL	Stock	7.0457	7.055	7.0393	7.0511	19042576.0
2010-02-23 15:30:00	AAPL	Stock	7.0507	7.0579	7.03	7.035	44147572.0
2010-02-23 16:00:00	AAPL	Stock	7.035	7.0861	7.0343	7.05	12607000.0
2010-02-23 16:30:00	AAPL	Stock	7.0494	7.0596	7.0375	7.0536	1378384.0
2010-02-23 17:00:00	AAPL	Stock	7.0514	7.0518	7.0454	7.0466	162456.0
2010-02-23 17:30:00	AAPL	Stock	7.05	7.05	7.05	7.05	2800.0
2010-02-23 18:00:00	AAPL	Stock	7.05	7.05	7.0379	7.0475	99484.0
2010-02-23 18:30:00	AAPL	Stock	7.0475	7.0496	7.0464	7.0464	56980.0
2010-02-23 19:00:00	AAPL	Stock	7.0454	7.0496	7.0454	7.0496	11200.0
2010-02-23 19:30:00	AAPL	Stock	7.0493	7.05	7.0486	7.0493	92876.0
2010-02-23 07:00:00	MSFT	Stock	28.75	28.75	28.75	28.75	500.0
2010-02-23 08:00:00	MSFT	Stock	28.69	28.69	28.69	28.69	1245.0
2010-02-23 08:30:00	MSFT	Stock	28.64	28.64	28.64	28.64	3700.0
2010-02-23 09:00:00	MSFT	Stock	28.64	28.73	28.64	28.67	1008691.0
2010-02-23 09:30:00	MSFT	Stock	28.68	28.83	28.56	28.6	5024110.0
2010-02-23 10:00:00	MSFT	Stock	28.6	28.61	28.26	28.314	7534606.0
2010-02-23 10:30:00	MSFT	Stock	28.32	28.32	28.12	28.165	6546723.0
2010-02-23 11:00:00	MSFT	Stock	28.165	28.24	28.15	28.17	3430858.0
2010-02-23 11:30:00	MSFT	Stock	28.177	28.26	28.17	28.2	2126383.0
2010-02-23 12:00:00	MSFT	Stock	28.2	28.24	28.11	28.11	2083156.0
2010-02-23 12:30:00	MSFT	Stock	28.11	28.24	28.09	28.24	2313165.0
2010-02-23 13:00:00	MSFT	Stock	28.24	28.305	28.19	28.28	3584062.0
2010-02-23 13:30:00	MSFT	Stock	28.28	28.29	28.22	28.25	2847445.0
2010-02-23 14:00:00	MSFT	Stock	28.25	28.34	28.18	28.31	2363650.0
2010-02-23 14:30:00	MSFT	Stock	28.304	28.45	28.28	28.41	2642719.0
2010-02-23 15:00:00	MSFT	Stock	28.41	28.46	28.36	28.37	2200862.0
2010-02-23 15:30:00	MSFT	Stock	28.371	28.38	28.29	28.34	4175462.0
2010-02-23 16:00:00	MSFT	Stock	28.33	28.39	28.28	28.288	2801566.0
2010-02-23 16:30:00	MSFT	Stock	28.386	28.42	28.33	28.4	226296.0
2010-02-23 17:00:00	MSFT	Stock	28.4	28.42	28.4	28.42	14480.0

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

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