PREVIEW / stock_5min / 2012-05-07

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-07.parquet
  size:    4.8 MB
  rows:    329,088
  symbols: 3,527

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-05-07 04:00:00	AAPL	Stock	20.0714	20.0714	20.0714	20.0714	2800.0
2012-05-07 04:10:00	AAPL	Stock	20.025	20.025	20.025	20.025	14000.0
2012-05-07 04:15:00	AAPL	Stock	20.0321	20.0321	20.0321	20.0321	10696.0
2012-05-07 04:20:00	AAPL	Stock	20.0325	20.0325	20.0325	20.0325	2800.0
2012-05-07 04:30:00	AAPL	Stock	20.0325	20.0325	20.0325	20.0325	2800.0
2012-05-07 04:35:00	AAPL	Stock	20.0325	20.0325	20.0325	20.0325	11200.0
2012-05-07 05:25:00	AAPL	Stock	20.1029	20.1029	20.1029	20.1029	2800.0
2012-05-07 05:30:00	AAPL	Stock	20.1029	20.1029	20.1029	20.1029	5600.0
2012-05-07 05:50:00	AAPL	Stock	20.1068	20.1071	20.1068	20.1071	9800.0
2012-05-07 05:55:00	AAPL	Stock	20.1243	20.125	20.1243	20.125	5600.0
2012-05-07 06:00:00	AAPL	Stock	20.1075	20.125	20.1075	20.125	5600.0
2012-05-07 06:05:00	AAPL	Stock	20.1293	20.1607	20.125	20.1607	11200.0
2012-05-07 06:10:00	AAPL	Stock	20.125	20.125	20.125	20.125	2800.0
2012-05-07 06:15:00	AAPL	Stock	20.1596	20.1596	20.1596	20.1596	5600.0
2012-05-07 06:40:00	AAPL	Stock	20.1596	20.1596	20.1596	20.1596	5880.0
2012-05-07 06:45:00	AAPL	Stock	20.15	20.15	20.15	20.15	5600.0
2012-05-07 07:00:00	AAPL	Stock	20.1082	20.1082	20.0754	20.0754	71568.0
2012-05-07 07:05:00	AAPL	Stock	20.0768	20.0821	20.0536	20.0539	208572.0
2012-05-07 07:10:00	AAPL	Stock	20.0536	20.0657	20.0214	20.0657	147616.0
2012-05-07 07:15:00	AAPL	Stock	20.0657	20.0657	20.0464	20.0464	47600.0
2012-05-07 07:20:00	AAPL	Stock	20.0375	20.0536	20.03	20.0536	179144.0
2012-05-07 07:25:00	AAPL	Stock	20.0471	20.0982	20.0379	20.0943	46312.0
2012-05-07 07:30:00	AAPL	Stock	20.0964	20.0964	20.0721	20.0893	63700.0
2012-05-07 07:35:00	AAPL	Stock	20.0896	20.0964	20.0821	20.0821	34524.0
2012-05-07 07:40:00	AAPL	Stock	20.0893	20.1	20.0782	20.0893	158032.0
2012-05-07 07:45:00	AAPL	Stock	20.0893	20.0893	20.0846	20.0846	37100.0
2012-05-07 07:50:00	AAPL	Stock	20.0943	20.0943	20.0807	20.0807	14560.0
2012-05-07 07:55:00	AAPL	Stock	20.0875	20.0982	20.0875	20.0964	66584.0
2012-05-07 08:00:00	AAPL	Stock	20.0821	20.1064	20.0379	20.0518	672364.0
2012-05-07 08:05:00	AAPL	Stock	20.0621	20.0782	20.0579	20.075	336700.0
2012-05-07 08:10:00	AAPL	Stock	20.075	20.0893	20.0486	20.0486	314244.0
2012-05-07 08:15:00	AAPL	Stock	20.0393	20.0393	20.0107	20.0189	595868.0
2012-05-07 08:20:00	AAPL	Stock	20.0143	20.0429	20.0143	20.0357	320712.0
2012-05-07 08:25:00	AAPL	Stock	20.0361	20.0604	20.0361	20.05	115948.0
2012-05-07 08:30:00	AAPL	Stock	20.0525	20.0525	20.0382	20.0382	55580.0
2012-05-07 08:35:00	AAPL	Stock	20.0421	20.0536	20.0414	20.0536	132160.0
2012-05-07 08:40:00	AAPL	Stock	20.0561	20.0679	20.0446	20.0586	237384.0
2012-05-07 08:45:00	AAPL	Stock	20.0643	20.0714	20.0575	20.0596	150584.0
2012-05-07 08:50:00	AAPL	Stock	20.0561	20.0604	20.0496	20.0604	110880.0
2012-05-07 08:55:00	AAPL	Stock	20.0604	20.1232	20.0604	20.1054	350560.0
2012-05-07 09:00:00	AAPL	Stock	20.1064	20.125	20.1054	20.1143	421148.0
2012-05-07 09:05:00	AAPL	Stock	20.1143	20.1143	20.1	20.1021	132132.0
2012-05-07 09:10:00	AAPL	Stock	20.1021	20.1021	20.09	20.09	216664.0
2012-05-07 09:15:00	AAPL	Stock	20.09	20.1586	20.0893	20.1536	434280.0
2012-05-07 09:20:00	AAPL	Stock	20.1589	20.1732	20.125	20.1421	648312.0
2012-05-07 09:25:00	AAPL	Stock	20.1421	20.1432	20.0536	20.0536	1306928.0
2012-05-07 09:30:00	AAPL	Stock	20.0643	20.2679	20.0439	20.2604	29088976.0
2012-05-07 09:35:00	AAPL	Stock	20.2679	20.3743	20.2438	20.3186	24901184.0
2012-05-07 09:40:00	AAPL	Stock	20.3221	20.4561	20.2939	20.4336	21152544.0
2012-05-07 09:45:00	AAPL	Stock	20.44	20.44	20.3236	20.3364	13944700.0

> showing 50 of 329,088 rows — these rows as CSV

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