PREVIEW / stock_30min / 2011-03-04

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-04.parquet
  size:    1.4 MB
  rows:    74,273
  symbols: 3,531

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-03-04 04:00:00	AAPL	Stock	12.8571	12.8571	12.8571	12.8571	2800.0
2011-03-04 05:00:00	AAPL	Stock	12.9	12.9	12.9	12.9	2800.0
2011-03-04 05:30:00	AAPL	Stock	12.9	12.9082	12.9	12.9082	27300.0
2011-03-04 06:00:00	AAPL	Stock	12.9154	12.9154	12.915	12.915	8400.0
2011-03-04 06:30:00	AAPL	Stock	12.9154	12.9154	12.9107	12.9107	19600.0
2011-03-04 07:00:00	AAPL	Stock	12.9018	12.9018	12.8682	12.8871	482720.0
2011-03-04 07:30:00	AAPL	Stock	12.8911	12.9011	12.8807	12.895	323624.0
2011-03-04 08:00:00	AAPL	Stock	12.8929	12.9168	12.8668	12.8964	2275952.0
2011-03-04 08:30:00	AAPL	Stock	12.9036	12.9229	12.8679	12.8736	3485636.0
2011-03-04 09:00:00	AAPL	Stock	12.8729	12.8879	12.8496	12.86	2780680.0
2011-03-04 09:30:00	AAPL	Stock	12.8596	12.8675	12.7989	12.827	83366752.0
2011-03-04 10:00:00	AAPL	Stock	12.8279	12.8307	12.7796	12.8011	51420544.0
2011-03-04 10:30:00	AAPL	Stock	12.8018	12.85	12.7904	12.8452	34719496.0
2011-03-04 11:00:00	AAPL	Stock	12.8446	12.8507	12.8232	12.8289	24630256.0
2011-03-04 11:30:00	AAPL	Stock	12.8292	12.8532	12.8218	12.8243	22059660.0
2011-03-04 12:00:00	AAPL	Stock	12.8236	12.8346	12.7811	12.7977	41947500.0
2011-03-04 12:30:00	AAPL	Stock	12.7977	12.8125	12.7768	12.7918	22221780.0
2011-03-04 13:00:00	AAPL	Stock	12.7923	12.8036	12.7843	12.7946	12493712.0
2011-03-04 13:30:00	AAPL	Stock	12.7961	12.8204	12.7954	12.8158	17836252.0
2011-03-04 14:00:00	AAPL	Stock	12.8193	12.82	12.7914	12.8139	12351304.0
2011-03-04 14:30:00	AAPL	Stock	12.8136	12.8214	12.8071	12.8211	10281656.0
2011-03-04 15:00:00	AAPL	Stock	12.8218	12.8425	12.7969	12.8089	27355608.0
2011-03-04 15:30:00	AAPL	Stock	12.8071	12.8571	12.7896	12.8571	50611652.0
2011-03-04 16:00:00	AAPL	Stock	12.8571	12.8607	12.8201	12.8561	8639764.0
2011-03-04 16:30:00	AAPL	Stock	12.8571	12.8579	12.8177	12.8568	411292.0
2011-03-04 17:00:00	AAPL	Stock	12.8568	12.8589	12.8554	12.8568	189056.0
2011-03-04 17:30:00	AAPL	Stock	12.8536	12.8561	12.8518	12.8518	44268.0
2011-03-04 18:00:00	AAPL	Stock	12.8536	12.8571	12.8536	12.8554	41972.0
2011-03-04 18:30:00	AAPL	Stock	12.8568	12.8625	12.8493	12.86	412412.0
2011-03-04 19:00:00	AAPL	Stock	12.8593	12.8593	12.8521	12.8539	79436.0
2011-03-04 19:30:00	AAPL	Stock	12.8568	12.8607	12.8561	12.8575	102480.0
2011-03-04 06:30:00	MSFT	Stock	26.35	26.35	26.35	26.35	200.0
2011-03-04 07:00:00	MSFT	Stock	26.3	26.36	26.3	26.35	1800.0
2011-03-04 07:30:00	MSFT	Stock	26.26	26.26	26.2	26.24	2600.0
2011-03-04 08:00:00	MSFT	Stock	26.23	26.3	26.23	26.3	22365.0
2011-03-04 08:30:00	MSFT	Stock	26.28	26.28	26.15	26.18	25099.0
2011-03-04 09:00:00	MSFT	Stock	26.18	26.24	26.15	26.22	27806.0
2011-03-04 09:30:00	MSFT	Stock	26.21	26.24	26.14	26.185	6917149.0
2011-03-04 10:00:00	MSFT	Stock	26.19	26.2	26.09	26.16	4370041.0
2011-03-04 10:30:00	MSFT	Stock	26.16	26.19	26.1	26.13	6840956.0
2011-03-04 11:00:00	MSFT	Stock	26.13	26.17	26.06	26.143	3138042.0
2011-03-04 11:30:00	MSFT	Stock	26.15	26.2	26.07	26.075	4148025.0
2011-03-04 12:00:00	MSFT	Stock	26.07	26.09	25.89	25.97	7659394.0
2011-03-04 12:30:00	MSFT	Stock	25.97	26.01	25.92	25.995	3068511.0
2011-03-04 13:00:00	MSFT	Stock	25.995	26.01	25.89	25.92	3800621.0
2011-03-04 13:30:00	MSFT	Stock	25.92	25.95	25.87	25.89	3365534.0
2011-03-04 14:00:00	MSFT	Stock	25.89	25.9	25.82	25.89	4341108.0
2011-03-04 14:30:00	MSFT	Stock	25.88	25.95	25.87	25.949	3409744.0
2011-03-04 15:00:00	MSFT	Stock	25.95	26.01	25.83	25.835	5118294.0
2011-03-04 15:30:00	MSFT	Stock	25.84	25.97	25.8	25.97	11541659.0

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

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