PREVIEW / stock_30min / 2012-04-30

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-30.parquet
  size:    1.4 MB
  rows:    75,226
  symbols: 3,551

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-04-30 04:00:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2012-04-30 05:30:00	AAPL	Stock	21.5643	21.5782	21.5643	21.5782	11200.0
2012-04-30 06:00:00	AAPL	Stock	21.5643	21.5643	21.5643	21.5643	14000.0
2012-04-30 06:30:00	AAPL	Stock	21.5539	21.5539	21.5107	21.5357	36400.0
2012-04-30 07:00:00	AAPL	Stock	21.5354	21.5354	21.4821	21.4821	75600.0
2012-04-30 07:30:00	AAPL	Stock	21.4821	21.4821	21.3911	21.3911	528080.0
2012-04-30 08:00:00	AAPL	Stock	21.4068	21.5	21.3161	21.3289	2607500.0
2012-04-30 08:30:00	AAPL	Stock	21.3311	21.4036	21.3161	21.3861	1909740.0
2012-04-30 09:00:00	AAPL	Stock	21.3861	21.3861	21.3268	21.3546	2144072.0
2012-04-30 09:30:00	AAPL	Stock	21.35	21.3714	21.0182	21.045	97666996.0
2012-04-30 10:00:00	AAPL	Stock	21.0443	21.1429	21.0089	21.0707	60613084.0
2012-04-30 10:30:00	AAPL	Stock	21.0686	21.1618	21.0261	21.1393	34190156.0
2012-04-30 11:00:00	AAPL	Stock	21.135	21.1504	21.0536	21.0661	19742240.0
2012-04-30 11:30:00	AAPL	Stock	21.0664	21.0696	20.9675	21.0389	35024780.0
2012-04-30 12:00:00	AAPL	Stock	21.0389	21.0446	20.8839	20.9285	38294984.0
2012-04-30 12:30:00	AAPL	Stock	20.9264	20.9857	20.9214	20.9421	16803444.0
2012-04-30 13:00:00	AAPL	Stock	20.9434	21.0071	20.9218	20.9636	15045016.0
2012-04-30 13:30:00	AAPL	Stock	20.9643	21.0234	20.9525	21.0114	16434880.0
2012-04-30 14:00:00	AAPL	Stock	21.0093	21.0236	20.9254	20.9354	18846996.0
2012-04-30 14:30:00	AAPL	Stock	20.9371	20.9429	20.8964	20.9011	21701344.0
2012-04-30 15:00:00	AAPL	Stock	20.9007	20.9368	20.8254	20.865	35854756.0
2012-04-30 15:30:00	AAPL	Stock	20.8643	20.9318	20.8214	20.8589	58595600.0
2012-04-30 16:00:00	AAPL	Stock	20.8582	21.0679	20.855	20.8679	19303508.0
2012-04-30 16:30:00	AAPL	Stock	20.8643	20.911	20.8536	20.875	2996504.0
2012-04-30 17:00:00	AAPL	Stock	20.875	20.8789	20.8571	20.8711	368144.0
2012-04-30 17:30:00	AAPL	Stock	20.8643	20.875	20.8571	20.8607	213136.0
2012-04-30 18:00:00	AAPL	Stock	20.8686	20.87	20.8536	20.8571	125160.0
2012-04-30 18:30:00	AAPL	Stock	20.8689	20.8739	20.8543	20.8543	84168.0
2012-04-30 19:00:00	AAPL	Stock	20.8521	20.8625	20.8486	20.85	136472.0
2012-04-30 19:30:00	AAPL	Stock	20.8589	20.8607	20.8393	20.8571	281120.0
2012-04-30 04:30:00	MSFT	Stock	31.86	31.86	31.86	31.86	500.0
2012-04-30 07:00:00	MSFT	Stock	32.19	32.19	32.15	32.19	1400.0
2012-04-30 07:30:00	MSFT	Stock	31.98	32.0	31.93	32.0	700.0
2012-04-30 08:00:00	MSFT	Stock	32.07	32.07	32.0	32.04	10799.0
2012-04-30 08:30:00	MSFT	Stock	32.04	32.04	32.02	32.02	2053.0
2012-04-30 09:00:00	MSFT	Stock	32.04	32.08	31.91	31.99	118922.0
2012-04-30 09:30:00	MSFT	Stock	31.99	32.11	31.92	31.98	3807378.0
2012-04-30 10:00:00	MSFT	Stock	31.98	32.04	31.935	31.986	2566304.0
2012-04-30 10:30:00	MSFT	Stock	31.99	32.04	31.97	32.0	1837443.0
2012-04-30 11:00:00	MSFT	Stock	31.995	32.03	31.96	31.99	1681602.0
2012-04-30 11:30:00	MSFT	Stock	32.0	32.01	31.96	31.985	1413181.0
2012-04-30 12:00:00	MSFT	Stock	31.99	32.01	31.95	31.986	1087291.0
2012-04-30 12:30:00	MSFT	Stock	31.99	32.01	31.98	31.99	810033.0
2012-04-30 13:00:00	MSFT	Stock	31.99	32.0	31.98	31.991	743219.0
2012-04-30 13:30:00	MSFT	Stock	32.0	32.01	31.97	32.0	1038041.0
2012-04-30 14:00:00	MSFT	Stock	32.01	32.03	31.99	32.01	3114932.0
2012-04-30 14:30:00	MSFT	Stock	32.02	32.035	31.99	32.03	3003642.0
2012-04-30 15:00:00	MSFT	Stock	32.03	32.04	32.01	32.025	2409103.0
2012-04-30 15:30:00	MSFT	Stock	32.03	32.07	31.99	32.02	6335639.0
2012-04-30 16:00:00	MSFT	Stock	32.01	32.02	31.97	32.02	4819813.0

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

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