PREVIEW / stock_30min / 2012-08-29

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-29.parquet
  size:    1.4 MB
  rows:    72,092
  symbols: 3,429

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-08-29 04:00:00	AAPL	Stock	24.1054	24.1054	24.1054	24.1054	22400.0
2012-08-29 05:00:00	AAPL	Stock	24.0986	24.0986	24.0911	24.0911	5600.0
2012-08-29 05:30:00	AAPL	Stock	24.1018	24.105	24.1018	24.105	5600.0
2012-08-29 06:30:00	AAPL	Stock	24.1139	24.1139	24.1139	24.1139	5600.0
2012-08-29 07:00:00	AAPL	Stock	24.1143	24.125	24.0893	24.0982	110040.0
2012-08-29 07:30:00	AAPL	Stock	24.0964	24.1064	24.0964	24.1064	17612.0
2012-08-29 08:00:00	AAPL	Stock	24.0954	24.1068	24.0464	24.0929	236068.0
2012-08-29 08:30:00	AAPL	Stock	24.0904	24.1307	24.0643	24.1307	790916.0
2012-08-29 09:00:00	AAPL	Stock	24.1339	24.1339	24.1143	24.1193	544516.0
2012-08-29 09:30:00	AAPL	Stock	24.1161	24.2025	24.0832	24.1436	43876476.0
2012-08-29 10:00:00	AAPL	Stock	24.1446	24.1782	24.1125	24.1236	20986952.0
2012-08-29 10:30:00	AAPL	Stock	24.1218	24.1304	24.0229	24.0329	22738828.0
2012-08-29 11:00:00	AAPL	Stock	24.0304	24.1025	24.0304	24.0846	14782068.0
2012-08-29 11:30:00	AAPL	Stock	24.0836	24.1304	24.0836	24.1011	11021892.0
2012-08-29 12:00:00	AAPL	Stock	24.1005	24.115	24.0771	24.1021	6093332.0
2012-08-29 12:30:00	AAPL	Stock	24.1054	24.1246	24.0832	24.1	5996732.0
2012-08-29 13:00:00	AAPL	Stock	24.1	24.1218	24.0786	24.1021	6691860.0
2012-08-29 13:30:00	AAPL	Stock	24.0996	24.1107	24.08	24.0927	7805112.0
2012-08-29 14:00:00	AAPL	Stock	24.0936	24.0957	24.055	24.0846	9643844.0
2012-08-29 14:30:00	AAPL	Stock	24.0846	24.0857	24.0421	24.06	6432636.0
2012-08-29 15:00:00	AAPL	Stock	24.06	24.0786	24.0493	24.0597	6559504.0
2012-08-29 15:30:00	AAPL	Stock	24.0575	24.0586	24.0214	24.0521	22332744.0
2012-08-29 16:00:00	AAPL	Stock	24.0582	24.1607	24.04	24.0536	11232032.0
2012-08-29 16:30:00	AAPL	Stock	24.0582	24.0665	24.0436	24.0475	233632.0
2012-08-29 17:00:00	AAPL	Stock	24.0493	24.0536	24.0429	24.0429	235592.0
2012-08-29 17:30:00	AAPL	Stock	24.0429	24.0536	24.0357	24.0518	147252.0
2012-08-29 18:00:00	AAPL	Stock	24.0521	24.0529	24.0429	24.0429	81032.0
2012-08-29 18:30:00	AAPL	Stock	24.0407	24.0479	24.0357	24.0446	135184.0
2012-08-29 19:00:00	AAPL	Stock	24.0436	24.0436	24.0361	24.0379	60648.0
2012-08-29 19:30:00	AAPL	Stock	24.0379	24.0507	24.0332	24.0507	202076.0
2012-08-29 06:30:00	MSFT	Stock	30.55	30.55	30.55	30.55	237.0
2012-08-29 08:00:00	MSFT	Stock	30.64	30.66	30.6	30.6	10932.0
2012-08-29 08:30:00	MSFT	Stock	30.6	30.65	30.6	30.65	3250.0
2012-08-29 09:00:00	MSFT	Stock	30.64	30.7	30.6	30.67	10195.0
2012-08-29 09:30:00	MSFT	Stock	30.652	30.75	30.58	30.63	2542736.0
2012-08-29 10:00:00	MSFT	Stock	30.635	30.71	30.62	30.66	2025048.0
2012-08-29 10:30:00	MSFT	Stock	30.66	30.68	30.44	30.485	1813543.0
2012-08-29 11:00:00	MSFT	Stock	30.48	30.52	30.45	30.51	1478400.0
2012-08-29 11:30:00	MSFT	Stock	30.51	30.6	30.51	30.595	933258.0
2012-08-29 12:00:00	MSFT	Stock	30.6	30.61	30.57	30.57	731595.0
2012-08-29 12:30:00	MSFT	Stock	30.575	30.63	30.56	30.61	984338.0
2012-08-29 13:00:00	MSFT	Stock	30.6	30.67	30.6	30.63	1943697.0
2012-08-29 13:30:00	MSFT	Stock	30.63	30.68	30.62	30.68	1363663.0
2012-08-29 14:00:00	MSFT	Stock	30.68	30.68	30.67	30.68	824248.0
2012-08-29 14:30:00	MSFT	Stock	30.67	30.7	30.65	30.65	1319529.0
2012-08-29 15:00:00	MSFT	Stock	30.65	30.66	30.64	30.655	1179532.0
2012-08-29 15:30:00	MSFT	Stock	30.65	30.69	30.62	30.63	3875104.0
2012-08-29 16:00:00	MSFT	Stock	30.62	30.738	30.512	30.64	1631311.0
2012-08-29 16:30:00	MSFT	Stock	30.65	30.65	30.63	30.65	43646.0
2012-08-29 17:00:00	MSFT	Stock	30.65	30.67	30.65	30.67	21102.0

> showing 50 of 72,092 rows — these rows as CSV

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