PREVIEW / stock_30min / 2011-04-11

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-11.parquet
  size:    1.4 MB
  rows:    75,085
  symbols: 3,552

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-04-11 04:00:00	AAPL	Stock	12.0029	12.0029	11.9996	11.9996	8400.0
2011-04-11 04:30:00	AAPL	Stock	11.9875	11.9929	11.9821	11.9821	22400.0
2011-04-11 05:00:00	AAPL	Stock	11.9857	11.9857	11.9786	11.9786	14000.0
2011-04-11 05:30:00	AAPL	Stock	11.9846	11.9846	11.9839	11.9839	5600.0
2011-04-11 06:00:00	AAPL	Stock	11.9836	12.0354	11.9679	12.0354	70560.0
2011-04-11 06:30:00	AAPL	Stock	12.0	12.0	12.0	12.0	16800.0
2011-04-11 07:00:00	AAPL	Stock	12.0011	12.0268	11.9875	12.0179	72716.0
2011-04-11 07:30:00	AAPL	Stock	12.0089	12.0089	11.9911	11.9918	58464.0
2011-04-11 08:00:00	AAPL	Stock	11.9979	11.9979	11.9464	11.9714	488264.0
2011-04-11 08:30:00	AAPL	Stock	11.9679	11.9679	11.9536	11.9607	482804.0
2011-04-11 09:00:00	AAPL	Stock	11.9571	12.1516	11.9271	11.9307	1131004.0
2011-04-11 09:30:00	AAPL	Stock	11.9282	11.9882	11.8671	11.9029	64370796.0
2011-04-11 10:00:00	AAPL	Stock	11.902	11.9243	11.872	11.8843	34369916.0
2011-04-11 10:30:00	AAPL	Stock	11.8821	11.8968	11.8571	11.8957	32590012.0
2011-04-11 11:00:00	AAPL	Stock	11.8957	11.9011	11.8589	11.8596	17797164.0
2011-04-11 11:30:00	AAPL	Stock	11.8614	11.8679	11.8036	11.8093	33243700.0
2011-04-11 12:00:00	AAPL	Stock	11.81	11.835	11.7864	11.8314	37848328.0
2011-04-11 12:30:00	AAPL	Stock	11.8304	11.8364	11.8004	11.8032	20600832.0
2011-04-11 13:00:00	AAPL	Stock	11.8032	11.8375	11.7918	11.8346	21059332.0
2011-04-11 13:30:00	AAPL	Stock	11.8336	11.8518	11.8211	11.835	19130580.0
2011-04-11 14:00:00	AAPL	Stock	11.8345	11.8464	11.8286	11.8419	10618216.0
2011-04-11 14:30:00	AAPL	Stock	11.8436	11.8496	11.8039	11.81	21383768.0
2011-04-11 15:00:00	AAPL	Stock	11.8091	11.815	11.7889	11.7946	27605144.0
2011-04-11 15:30:00	AAPL	Stock	11.7943	11.8214	11.7893	11.8211	40091912.0
2011-04-11 16:00:00	AAPL	Stock	11.8211	11.883	11.8056	11.8171	8758680.0
2011-04-11 16:30:00	AAPL	Stock	11.8175	11.8214	11.7947	11.8139	486640.0
2011-04-11 17:00:00	AAPL	Stock	11.8139	11.9452	11.7918	11.7918	233184.0
2011-04-11 17:30:00	AAPL	Stock	11.7946	11.8071	11.7946	11.8	67900.0
2011-04-11 18:00:00	AAPL	Stock	11.7979	11.8143	11.7932	11.7939	173376.0
2011-04-11 18:30:00	AAPL	Stock	11.7964	11.8036	11.7964	11.8036	35868.0
2011-04-11 19:00:00	AAPL	Stock	11.8011	11.8054	11.8	11.8	48692.0
2011-04-11 19:30:00	AAPL	Stock	11.8	11.8	11.7936	11.8	98840.0
2011-04-11 05:00:00	MSFT	Stock	26.25	26.25	26.25	26.25	1000.0
2011-04-11 05:30:00	MSFT	Stock	26.24	26.24	26.24	26.24	200.0
2011-04-11 06:00:00	MSFT	Stock	26.24	26.25	26.24	26.25	200.0
2011-04-11 07:00:00	MSFT	Stock	26.23	26.23	26.23	26.23	1000.0
2011-04-11 07:30:00	MSFT	Stock	26.21	26.24	26.19	26.19	6100.0
2011-04-11 08:00:00	MSFT	Stock	26.18	26.21	26.16	26.17	10420.0
2011-04-11 08:30:00	MSFT	Stock	26.17	26.18	26.16	26.16	7326.0
2011-04-11 09:00:00	MSFT	Stock	26.17	26.21	26.12	26.18	68631.0
2011-04-11 09:30:00	MSFT	Stock	26.18	26.25	26.11	26.13	3548663.0
2011-04-11 10:00:00	MSFT	Stock	26.14	26.14	26.01	26.095	2446361.0
2011-04-11 10:30:00	MSFT	Stock	26.09	26.18	26.09	26.137	2080282.0
2011-04-11 11:00:00	MSFT	Stock	26.13	26.14	26.07	26.07	1584049.0
2011-04-11 11:30:00	MSFT	Stock	26.07	26.12	26.02	26.02	2063441.0
2011-04-11 12:00:00	MSFT	Stock	26.025	26.05	26.0	26.035	1691443.0
2011-04-11 12:30:00	MSFT	Stock	26.03	26.04	25.96	25.99	1495883.0
2011-04-11 13:00:00	MSFT	Stock	25.98	25.99	25.87	25.918	3158116.0
2011-04-11 13:30:00	MSFT	Stock	25.92	25.94	25.821	25.87	2635732.0
2011-04-11 14:00:00	MSFT	Stock	25.88	25.9	25.84	25.88	1227992.0

> showing 50 of 75,085 rows — these rows as CSV

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