PREVIEW / stock_30min / 2014-03-19

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-19.parquet
  size:    1.6 MB
  rows:    82,083
  symbols: 3,540

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
2014-03-19 05:00:00	AAPL	Stock	19.0264	19.0304	19.0182	19.0182	16800.0
2014-03-19 05:30:00	AAPL	Stock	19.0236	19.0236	19.0179	19.0229	14000.0
2014-03-19 06:00:00	AAPL	Stock	19.0243	19.0243	19.0239	19.0239	5600.0
2014-03-19 06:30:00	AAPL	Stock	19.0196	19.0196	19.0196	19.0196	5600.0
2014-03-19 07:00:00	AAPL	Stock	19.0211	19.05	19.0211	19.0357	50596.0
2014-03-19 07:30:00	AAPL	Stock	19.0357	19.0357	19.0286	19.035	8400.0
2014-03-19 08:00:00	AAPL	Stock	19.0475	19.0475	19.0129	19.0339	167608.0
2014-03-19 08:30:00	AAPL	Stock	19.0239	19.0518	19.0239	19.0511	349272.0
2014-03-19 09:00:00	AAPL	Stock	19.0482	19.06	19.0014	19.0093	973084.0
2014-03-19 09:30:00	AAPL	Stock	19.0104	19.1268	18.97	19.1139	34691692.0
2014-03-19 10:00:00	AAPL	Stock	19.1136	19.1514	19.0949	19.1111	20518288.0
2014-03-19 10:30:00	AAPL	Stock	19.1096	19.1118	19.055	19.0892	12164684.0
2014-03-19 11:00:00	AAPL	Stock	19.0911	19.1282	19.0761	19.1138	8143800.0
2014-03-19 11:30:00	AAPL	Stock	19.1157	19.1168	19.0904	19.1068	6064632.0
2014-03-19 12:00:00	AAPL	Stock	19.105	19.1168	19.0946	19.1036	5803952.0
2014-03-19 12:30:00	AAPL	Stock	19.1	19.1171	19.0979	19.1157	5823580.0
2014-03-19 13:00:00	AAPL	Stock	19.1161	19.1321	19.1086	19.125	4963336.0
2014-03-19 13:30:00	AAPL	Stock	19.1268	19.1279	19.0893	19.0936	4289852.0
2014-03-19 14:00:00	AAPL	Stock	19.1004	19.1004	19.0271	19.0689	15100876.0
2014-03-19 14:30:00	AAPL	Stock	19.0725	19.0882	19.0196	19.0352	11101916.0
2014-03-19 15:00:00	AAPL	Stock	19.0343	19.05	18.8929	18.9429	24649996.0
2014-03-19 15:30:00	AAPL	Stock	18.9429	19.0032	18.9264	18.9736	19922896.0
2014-03-19 16:00:00	AAPL	Stock	18.9736	19.1008	18.9557	18.985	9394504.0
2014-03-19 16:30:00	AAPL	Stock	18.9857	18.9864	18.9736	18.9821	237552.0
2014-03-19 17:00:00	AAPL	Stock	18.9821	18.9893	18.9821	18.9857	50400.0
2014-03-19 17:30:00	AAPL	Stock	18.99	18.9911	18.9736	18.9736	238952.0
2014-03-19 18:00:00	AAPL	Stock	18.9911	19.0	18.9911	19.0	47432.0
2014-03-19 19:00:00	AAPL	Stock	18.9918	18.9996	18.9822	18.9996	28280.0
2014-03-19 19:30:00	AAPL	Stock	18.9861	19.0	18.9861	19.0	59948.0
2014-03-19 05:00:00	MSFT	Stock	39.66	39.66	39.66	39.66	793.0
2014-03-19 05:30:00	MSFT	Stock	39.79	39.79	39.65	39.73	1277.0
2014-03-19 06:00:00	MSFT	Stock	39.77	39.77	39.75	39.77	5400.0
2014-03-19 06:30:00	MSFT	Stock	39.75	39.78	39.66	39.66	6167.0
2014-03-19 07:00:00	MSFT	Stock	39.66	39.7	39.66	39.7	3000.0
2014-03-19 07:30:00	MSFT	Stock	39.68	39.69	39.6	39.6	2677.0
2014-03-19 08:00:00	MSFT	Stock	39.62	39.78	39.57	39.57	15727.0
2014-03-19 08:30:00	MSFT	Stock	39.55	39.6	39.47	39.47	35739.0
2014-03-19 09:00:00	MSFT	Stock	39.5	39.53	39.31	39.44	40734.0
2014-03-19 09:30:00	MSFT	Stock	39.47	39.55	39.24	39.35	5436618.0
2014-03-19 10:00:00	MSFT	Stock	39.35	39.49	39.24	39.27	3922879.0
2014-03-19 10:30:00	MSFT	Stock	39.26	39.32	39.18	39.266	2616449.0
2014-03-19 11:00:00	MSFT	Stock	39.26	39.34	39.254	39.312	1470382.0
2014-03-19 11:30:00	MSFT	Stock	39.319	39.33	39.22	39.31	1703590.0
2014-03-19 12:00:00	MSFT	Stock	39.31	39.35	39.26	39.265	997888.0
2014-03-19 12:30:00	MSFT	Stock	39.265	39.39	39.25	39.38	1453341.0
2014-03-19 13:00:00	MSFT	Stock	39.38	39.39	39.3	39.34	926594.0
2014-03-19 13:30:00	MSFT	Stock	39.34	39.45	39.33	39.445	978521.0
2014-03-19 14:00:00	MSFT	Stock	39.45	39.48	39.24	39.4	3276022.0
2014-03-19 14:30:00	MSFT	Stock	39.396	39.45	39.284	39.37	1354606.0
2014-03-19 15:00:00	MSFT	Stock	39.37	39.37	38.91	39.17	3850780.0

> showing 50 of 82,083 rows — these rows as CSV

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