PREVIEW / stock_30min / 2014-10-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-17.parquet
  size:    1.6 MB
  rows:    84,842
  symbols: 3,557

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-10-17 04:00:00	AAPL	Stock	24.185	24.3	24.1375	24.3	13656.0
2014-10-17 04:30:00	AAPL	Stock	24.3225	24.325	24.3	24.325	25176.0
2014-10-17 05:00:00	AAPL	Stock	24.33	24.3475	24.3225	24.3475	6760.0
2014-10-17 05:30:00	AAPL	Stock	24.37	24.3975	24.355	24.3975	10552.0
2014-10-17 06:00:00	AAPL	Stock	24.3975	24.4225	24.35	24.4225	81372.0
2014-10-17 06:30:00	AAPL	Stock	24.42	24.42	24.3575	24.38	54276.0
2014-10-17 07:00:00	AAPL	Stock	24.38	24.38	24.3	24.34	173572.0
2014-10-17 07:30:00	AAPL	Stock	24.34	24.3525	24.325	24.3325	125804.0
2014-10-17 08:00:00	AAPL	Stock	24.33	24.415	24.3125	24.3625	742800.0
2014-10-17 08:30:00	AAPL	Stock	24.3725	24.4025	24.3525	24.3625	498284.0
2014-10-17 09:00:00	AAPL	Stock	24.375	24.4125	24.33	24.375	1467240.0
2014-10-17 09:30:00	AAPL	Stock	24.39	24.4375	24.2025	24.3475	44136968.0
2014-10-17 10:00:00	AAPL	Stock	24.345	24.455	24.335	24.45	18949944.0
2014-10-17 10:30:00	AAPL	Stock	24.45	24.51	24.4025	24.4975	17419612.0
2014-10-17 11:00:00	AAPL	Stock	24.4975	24.6025	24.4775	24.595	16741696.0
2014-10-17 11:30:00	AAPL	Stock	24.595	24.75	24.575	24.685	19127412.0
2014-10-17 12:00:00	AAPL	Stock	24.6825	24.7075	24.535	24.5538	16747724.0
2014-10-17 12:30:00	AAPL	Stock	24.5525	24.62	24.4875	24.5338	12441700.0
2014-10-17 13:00:00	AAPL	Stock	24.5325	24.5625	24.475	24.5275	10652196.0
2014-10-17 13:30:00	AAPL	Stock	24.5275	24.585	24.525	24.5375	10579916.0
2014-10-17 14:00:00	AAPL	Stock	24.535	24.5362	24.415	24.4625	13125356.0
2014-10-17 14:30:00	AAPL	Stock	24.4625	24.485	24.425	24.4575	9535744.0
2014-10-17 15:00:00	AAPL	Stock	24.4575	24.4775	24.375	24.46	16487208.0
2014-10-17 15:30:00	AAPL	Stock	24.4592	24.51	24.4125	24.415	27646364.0
2014-10-17 16:00:00	AAPL	Stock	24.4175	24.4748	24.39	24.425	17162696.0
2014-10-17 16:30:00	AAPL	Stock	24.425	24.515	24.4175	24.4425	486696.0
2014-10-17 17:00:00	AAPL	Stock	24.45	24.4965	24.44	24.49	88720.0
2014-10-17 17:30:00	AAPL	Stock	24.49	24.5	24.4175	24.4975	929148.0
2014-10-17 18:00:00	AAPL	Stock	24.4975	24.5375	24.4175	24.5325	314384.0
2014-10-17 18:30:00	AAPL	Stock	24.535	24.535	24.4175	24.5125	277992.0
2014-10-17 19:00:00	AAPL	Stock	24.505	24.5225	24.495	24.505	77528.0
2014-10-17 19:30:00	AAPL	Stock	24.51	24.535	24.51	24.5325	177324.0
2014-10-17 04:00:00	MSFT	Stock	42.98	42.98	42.98	42.98	100.0
2014-10-17 07:00:00	MSFT	Stock	43.1	43.1	43.1	43.1	2550.0
2014-10-17 07:30:00	MSFT	Stock	43.13	43.14	43.13	43.14	1860.0
2014-10-17 08:00:00	MSFT	Stock	43.19	43.2	43.13	43.2	4080.0
2014-10-17 08:30:00	MSFT	Stock	43.3	43.3	43.15	43.2	18635.0
2014-10-17 09:00:00	MSFT	Stock	43.19	43.26	43.17	43.26	187055.0
2014-10-17 09:30:00	MSFT	Stock	43.26	43.33	42.79	43.005	9664859.0
2014-10-17 10:00:00	MSFT	Stock	43.005	43.455	42.9	43.44	3122639.0
2014-10-17 10:30:00	MSFT	Stock	43.45	43.48	43.3	43.445	2450087.0
2014-10-17 11:00:00	MSFT	Stock	43.44	43.85	43.35	43.783	2334698.0
2014-10-17 11:30:00	MSFT	Stock	43.78	43.91	43.73	43.755	1638824.0
2014-10-17 12:00:00	MSFT	Stock	43.75	43.8	43.635	43.69	1622271.0
2014-10-17 12:30:00	MSFT	Stock	43.69	43.78	43.65	43.74	1274735.0
2014-10-17 13:00:00	MSFT	Stock	43.74	43.77	43.47	43.47	1788126.0
2014-10-17 13:30:00	MSFT	Stock	43.47	43.696	43.45	43.58	1565585.0
2014-10-17 14:00:00	MSFT	Stock	43.57	43.63	43.43	43.607	1963796.0
2014-10-17 14:30:00	MSFT	Stock	43.6	43.685	43.55	43.63	1406108.0
2014-10-17 15:00:00	MSFT	Stock	43.625	43.8	43.44	43.773	2029134.0

> showing 50 of 84,842 rows — these rows as CSV

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