PREVIEW / stock_30min / 2014-10-01

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-01.parquet
  size:    1.6 MB
  rows:    84,582
  symbols: 3,579

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-01 04:00:00	AAPL	Stock	25.125	25.125	25.1175	25.125	6000.0
2014-10-01 04:30:00	AAPL	Stock	25.125	25.135	25.1	25.135	3000.0
2014-10-01 05:00:00	AAPL	Stock	25.1425	25.15	25.1425	25.15	4400.0
2014-10-01 05:30:00	AAPL	Stock	25.1425	25.1425	25.1425	25.1425	600.0
2014-10-01 06:00:00	AAPL	Stock	25.16	25.175	25.16	25.175	3320.0
2014-10-01 06:30:00	AAPL	Stock	25.1625	25.1625	25.1625	25.1625	5572.0
2014-10-01 07:00:00	AAPL	Stock	25.1675	25.18	25.165	25.165	28680.0
2014-10-01 07:30:00	AAPL	Stock	25.1525	25.155	25.095	25.1125	66048.0
2014-10-01 08:00:00	AAPL	Stock	25.1125	25.1875	25.0625	25.125	250484.0
2014-10-01 08:30:00	AAPL	Stock	25.12	25.1875	25.1125	25.17	172056.0
2014-10-01 09:00:00	AAPL	Stock	25.17	25.2	25.1425	25.1475	278264.0
2014-10-01 09:30:00	AAPL	Stock	25.15	25.1725	24.9412	24.9625	24988268.0
2014-10-01 10:00:00	AAPL	Stock	24.9625	24.9875	24.875	24.96	19303556.0
2014-10-01 10:30:00	AAPL	Stock	24.96	25.0	24.9	24.995	12686600.0
2014-10-01 11:00:00	AAPL	Stock	24.995	25.075	24.955	24.979	14040520.0
2014-10-01 11:30:00	AAPL	Stock	24.9775	24.9925	24.9175	24.9625	7433052.0
2014-10-01 12:00:00	AAPL	Stock	24.9638	24.9725	24.9175	24.97	6674572.0
2014-10-01 12:30:00	AAPL	Stock	24.9675	24.97	24.8875	24.8958	7744396.0
2014-10-01 13:00:00	AAPL	Stock	24.8975	24.9225	24.8775	24.8975	9831968.0
2014-10-01 13:30:00	AAPL	Stock	24.895	24.8975	24.725	24.74	18280276.0
2014-10-01 14:00:00	AAPL	Stock	24.74	24.855	24.7175	24.805	11809388.0
2014-10-01 14:30:00	AAPL	Stock	24.805	24.8125	24.6925	24.7125	11657764.0
2014-10-01 15:00:00	AAPL	Stock	24.7125	24.79	24.675	24.77	16135284.0
2014-10-01 15:30:00	AAPL	Stock	24.77	24.8625	24.765	24.7975	23716776.0
2014-10-01 16:00:00	AAPL	Stock	24.795	24.8905	24.795	24.8125	8913928.0
2014-10-01 16:30:00	AAPL	Stock	24.976	24.976	24.7692	24.8125	362852.0
2014-10-01 17:00:00	AAPL	Stock	24.8075	24.8175	24.8	24.805	36584.0
2014-10-01 17:30:00	AAPL	Stock	24.8075	24.835	24.8075	24.835	6584.0
2014-10-01 18:00:00	AAPL	Stock	24.8325	24.8325	24.795	24.825	164708.0
2014-10-01 18:30:00	AAPL	Stock	24.825	24.85	24.825	24.8325	79156.0
2014-10-01 19:00:00	AAPL	Stock	24.8275	24.835	24.825	24.835	20200.0
2014-10-01 19:30:00	AAPL	Stock	24.835	24.8375	24.7975	24.8075	69256.0
2014-10-01 08:00:00	MSFT	Stock	46.36	46.36	46.21	46.21	2155.0
2014-10-01 09:00:00	MSFT	Stock	46.26	46.28	46.26	46.28	200.0
2014-10-01 09:30:00	MSFT	Stock	46.27	46.53	46.22	46.24	3771188.0
2014-10-01 10:00:00	MSFT	Stock	46.235	46.31	45.95	46.305	3382348.0
2014-10-01 10:30:00	MSFT	Stock	46.305	46.32	46.173	46.3	2190546.0
2014-10-01 11:00:00	MSFT	Stock	46.295	46.36	46.265	46.3	2300233.0
2014-10-01 11:30:00	MSFT	Stock	46.3	46.37	46.25	46.34	1716903.0
2014-10-01 12:00:00	MSFT	Stock	46.335	46.35	46.2	46.285	1969963.0
2014-10-01 12:30:00	MSFT	Stock	46.285	46.285	46.07	46.135	1926728.0
2014-10-01 13:00:00	MSFT	Stock	46.13	46.18	46.1	46.155	1305852.0
2014-10-01 13:30:00	MSFT	Stock	46.17	46.17	45.9	45.907	2232725.0
2014-10-01 14:00:00	MSFT	Stock	45.905	46.03	45.9	45.96	1766906.0
2014-10-01 14:30:00	MSFT	Stock	45.96	45.96	45.845	45.855	1597638.0
2014-10-01 15:00:00	MSFT	Stock	45.86	46.0	45.855	45.97	1921985.0
2014-10-01 15:30:00	MSFT	Stock	45.973	46.06	45.91	45.91	5318013.0
2014-10-01 16:00:00	MSFT	Stock	45.9	46.131	45.9	45.9	5435844.0
2014-10-01 16:30:00	MSFT	Stock	45.95	45.95	45.9	45.9	59565.0
2014-10-01 17:30:00	MSFT	Stock	45.91	45.91	45.91	45.91	262.0

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

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