PREVIEW / stock_30min / 2013-05-23

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-23.parquet
  size:    1.5 MB
  rows:    80,280
  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
2013-05-23 04:00:00	AAPL	Stock	15.7857	15.7857	15.5714	15.5718	60200.0
2013-05-23 04:30:00	AAPL	Stock	15.5718	15.5718	15.5696	15.57	25816.0
2013-05-23 05:00:00	AAPL	Stock	15.5539	15.5539	15.5282	15.5518	130704.0
2013-05-23 05:30:00	AAPL	Stock	15.5518	15.5518	15.5	15.5179	113176.0
2013-05-23 06:00:00	AAPL	Stock	15.5036	15.5357	15.5036	15.5357	20132.0
2013-05-23 06:30:00	AAPL	Stock	15.5482	15.5904	15.5396	15.575	106932.0
2013-05-23 07:00:00	AAPL	Stock	15.5671	15.6429	15.5671	15.6107	214984.0
2013-05-23 07:30:00	AAPL	Stock	15.6114	15.6125	15.5857	15.5943	337456.0
2013-05-23 08:00:00	AAPL	Stock	15.6029	15.7143	15.5714	15.625	1715224.0
2013-05-23 08:30:00	AAPL	Stock	15.625	15.6482	15.6093	15.6118	1669612.0
2013-05-23 09:00:00	AAPL	Stock	15.6132	15.6304	15.5607	15.5704	2039996.0
2013-05-23 09:30:00	AAPL	Stock	15.5714	15.7068	15.5639	15.6482	64703912.0
2013-05-23 10:00:00	AAPL	Stock	15.6511	15.9204	15.6307	15.9018	68383728.0
2013-05-23 10:30:00	AAPL	Stock	15.9021	15.9343	15.8079	15.8543	41059004.0
2013-05-23 11:00:00	AAPL	Stock	15.8579	15.9092	15.8286	15.8449	18021948.0
2013-05-23 11:30:00	AAPL	Stock	15.8407	15.8786	15.8146	15.8379	14599928.0
2013-05-23 12:00:00	AAPL	Stock	15.8318	15.8704	15.8179	15.8218	15091776.0
2013-05-23 12:30:00	AAPL	Stock	15.8264	15.8421	15.7882	15.8379	15299172.0
2013-05-23 13:00:00	AAPL	Stock	15.8404	15.8407	15.7511	15.7657	12992084.0
2013-05-23 13:30:00	AAPL	Stock	15.7629	15.8032	15.7371	15.7957	14213612.0
2013-05-23 14:00:00	AAPL	Stock	15.7925	15.8521	15.7821	15.825	14555632.0
2013-05-23 14:30:00	AAPL	Stock	15.8225	15.8793	15.7989	15.85	15875524.0
2013-05-23 15:00:00	AAPL	Stock	15.8521	15.8675	15.7936	15.8111	15182636.0
2013-05-23 15:30:00	AAPL	Stock	15.8111	15.8446	15.7875	15.7925	25008564.0
2013-05-23 16:00:00	AAPL	Stock	15.7921	15.8396	15.7843	15.8093	8207388.0
2013-05-23 16:30:00	AAPL	Stock	15.8651	15.8651	15.7907	15.8254	693252.0
2013-05-23 17:00:00	AAPL	Stock	15.8214	15.8254	15.7907	15.825	257432.0
2013-05-23 17:30:00	AAPL	Stock	15.8282	15.8289	15.8221	15.825	19600.0
2013-05-23 18:00:00	AAPL	Stock	15.8246	15.8282	15.8246	15.825	40740.0
2013-05-23 18:30:00	AAPL	Stock	15.8246	15.8279	15.8246	15.8279	16716.0
2013-05-23 19:00:00	AAPL	Stock	15.8268	15.8268	15.7907	15.825	141204.0
2013-05-23 19:30:00	AAPL	Stock	15.8254	15.8482	15.8254	15.8429	203504.0
2013-05-23 04:30:00	MSFT	Stock	34.11	34.2	34.02	34.02	4495.0
2013-05-23 05:30:00	MSFT	Stock	34.11	34.13	34.11	34.13	700.0
2013-05-23 06:00:00	MSFT	Stock	34.15	34.2	34.15	34.2	2430.0
2013-05-23 06:30:00	MSFT	Stock	34.18	34.3	34.13	34.3	5447.0
2013-05-23 07:00:00	MSFT	Stock	34.2	34.29	34.15	34.24	27600.0
2013-05-23 07:30:00	MSFT	Stock	34.24	34.24	34.18	34.24	5083.0
2013-05-23 08:00:00	MSFT	Stock	34.18	34.25	34.15	34.15	36565.0
2013-05-23 08:30:00	MSFT	Stock	34.17	34.24	34.15	34.21	49253.0
2013-05-23 09:00:00	MSFT	Stock	34.2	34.28	34.11	34.2	129381.0
2013-05-23 09:30:00	MSFT	Stock	34.19	34.46	33.9	34.02	10211030.0
2013-05-23 10:00:00	MSFT	Stock	34.02	34.35	33.98	34.25	6318930.0
2013-05-23 10:30:00	MSFT	Stock	34.251	34.3	34.15	34.15	2924913.0
2013-05-23 11:00:00	MSFT	Stock	34.14	34.32	34.13	34.24	2476247.0
2013-05-23 11:30:00	MSFT	Stock	34.24	34.55	34.225	34.45	3266455.0
2013-05-23 12:00:00	MSFT	Stock	34.45	34.48	34.322	34.331	1743068.0
2013-05-23 12:30:00	MSFT	Stock	34.335	34.36	34.26	34.3	1780203.0
2013-05-23 13:00:00	MSFT	Stock	34.3	34.32	34.22	34.23	2217134.0
2013-05-23 13:30:00	MSFT	Stock	34.23	34.275	34.17	34.27	1435485.0

> showing 50 of 80,280 rows — these rows as CSV

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