PREVIEW / stock_30min / 2013-09-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-04.parquet
  size:    1.5 MB
  rows:    79,274
  symbols: 3,516

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-09-04 04:00:00	AAPL	Stock	17.4464	17.4464	17.4464	17.4464	9660.0
2013-09-04 04:30:00	AAPL	Stock	17.4225	17.4375	17.4171	17.4375	39200.0
2013-09-04 05:00:00	AAPL	Stock	17.4332	17.4332	17.4332	17.4332	2800.0
2013-09-04 06:00:00	AAPL	Stock	17.4607	17.4875	17.4125	17.4875	16800.0
2013-09-04 06:30:00	AAPL	Stock	17.4871	17.6071	17.485	17.6071	217840.0
2013-09-04 07:00:00	AAPL	Stock	17.6071	17.7475	17.6071	17.7475	1026396.0
2013-09-04 07:30:00	AAPL	Stock	17.7336	17.8532	17.7143	17.8304	2036412.0
2013-09-04 08:00:00	AAPL	Stock	17.8225	17.8568	17.7146	17.8179	4120200.0
2013-09-04 08:30:00	AAPL	Stock	17.8204	17.8371	17.775	17.8264	2370480.0
2013-09-04 09:00:00	AAPL	Stock	17.825	17.9375	17.8214	17.8564	8400280.0
2013-09-04 09:30:00	AAPL	Stock	17.8425	17.9371	17.7618	17.78	97369048.0
2013-09-04 10:00:00	AAPL	Stock	17.78	17.8461	17.7664	17.7995	34865180.0
2013-09-04 10:30:00	AAPL	Stock	17.8077	17.8654	17.7807	17.8512	24177860.0
2013-09-04 11:00:00	AAPL	Stock	17.8543	17.8554	17.7822	17.8248	13785856.0
2013-09-04 11:30:00	AAPL	Stock	17.8268	17.8571	17.8136	17.8483	15149624.0
2013-09-04 12:00:00	AAPL	Stock	17.8482	17.8518	17.7889	17.8243	16254392.0
2013-09-04 12:30:00	AAPL	Stock	17.8243	17.8407	17.8182	17.83	8869476.0
2013-09-04 13:00:00	AAPL	Stock	17.8296	17.8604	17.7996	17.8421	14571284.0
2013-09-04 13:30:00	AAPL	Stock	17.8411	17.8447	17.8157	17.8314	8946112.0
2013-09-04 14:00:00	AAPL	Stock	17.8296	17.8446	17.8146	17.8168	8592052.0
2013-09-04 14:30:00	AAPL	Stock	17.8175	17.8336	17.8036	17.8255	9960664.0
2013-09-04 15:00:00	AAPL	Stock	17.8239	17.83	17.7243	17.7564	25315304.0
2013-09-04 15:30:00	AAPL	Stock	17.7564	17.8189	17.7468	17.8089	30386468.0
2013-09-04 16:00:00	AAPL	Stock	17.8114	17.8242	17.7821	17.8161	12373676.0
2013-09-04 16:30:00	AAPL	Stock	17.8164	17.8214	17.8107	17.8129	568764.0
2013-09-04 17:00:00	AAPL	Stock	17.8207	17.8311	17.8129	17.8282	615888.0
2013-09-04 17:30:00	AAPL	Stock	17.8279	17.8307	17.8214	17.8307	116536.0
2013-09-04 18:00:00	AAPL	Stock	17.8307	17.8464	17.8304	17.8457	186536.0
2013-09-04 18:30:00	AAPL	Stock	17.8382	17.8457	17.8129	17.8393	180124.0
2013-09-04 19:00:00	AAPL	Stock	17.8421	17.8568	17.8368	17.8464	123760.0
2013-09-04 19:30:00	AAPL	Stock	17.8518	17.875	17.8464	17.875	343280.0
2013-09-04 04:00:00	MSFT	Stock	31.82	31.82	31.61	31.8	3500.0
2013-09-04 04:30:00	MSFT	Stock	31.62	31.62	31.61	31.61	3300.0
2013-09-04 05:30:00	MSFT	Stock	31.75	31.75	31.75	31.75	500.0
2013-09-04 06:00:00	MSFT	Stock	31.7	31.7	31.7	31.7	100.0
2013-09-04 06:30:00	MSFT	Stock	31.74	31.74	31.65	31.68	3874.0
2013-09-04 07:00:00	MSFT	Stock	31.7	31.72	31.68	31.68	6500.0
2013-09-04 07:30:00	MSFT	Stock	31.7	31.7	31.65	31.65	22002.0
2013-09-04 08:00:00	MSFT	Stock	31.68	31.7	31.62	31.65	82167.0
2013-09-04 08:30:00	MSFT	Stock	31.67	31.67	31.5	31.57	81298.0
2013-09-04 09:00:00	MSFT	Stock	31.56	31.57	31.2	31.4	849873.0
2013-09-04 09:30:00	MSFT	Stock	31.4	31.47	31.25	31.32	19201224.0
2013-09-04 10:00:00	MSFT	Stock	31.32	31.34	31.18	31.23	25183276.0
2013-09-04 10:30:00	MSFT	Stock	31.23	31.25	31.11	31.22	8358536.0
2013-09-04 11:00:00	MSFT	Stock	31.219	31.24	31.13	31.16	8714549.0
2013-09-04 11:30:00	MSFT	Stock	31.165	31.26	31.15	31.225	9082461.0
2013-09-04 12:00:00	MSFT	Stock	31.225	31.25	31.2	31.219	4646300.0
2013-09-04 12:30:00	MSFT	Stock	31.213	31.25	31.19	31.235	4666880.0
2013-09-04 13:00:00	MSFT	Stock	31.235	31.27	31.21	31.23	2645350.0
2013-09-04 13:30:00	MSFT	Stock	31.24	31.245	31.17	31.18	3409135.0

> showing 50 of 79,274 rows — these rows as CSV

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