PREVIEW / stock_30min / 2015-07-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-20.parquet
  size:    1.6 MB
  rows:    82,503
  symbols: 3,507

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
2015-07-20 04:00:00	AAPL	Stock	32.5	32.5625	32.5	32.5625	38648.0
2015-07-20 04:30:00	AAPL	Stock	32.555	32.62	32.5425	32.5775	49948.0
2015-07-20 05:00:00	AAPL	Stock	32.6225	32.6225	32.575	32.6125	35028.0
2015-07-20 05:30:00	AAPL	Stock	32.6125	32.625	32.605	32.625	18040.0
2015-07-20 06:00:00	AAPL	Stock	32.625	32.6625	32.625	32.6625	43816.0
2015-07-20 06:30:00	AAPL	Stock	32.6725	32.7075	32.665	32.6775	80144.0
2015-07-20 07:00:00	AAPL	Stock	32.6875	32.7925	32.6875	32.785	217552.0
2015-07-20 07:30:00	AAPL	Stock	32.775	32.92	32.765	32.9125	473920.0
2015-07-20 08:00:00	AAPL	Stock	32.92	32.92	32.6375	32.8875	1223148.0
2015-07-20 08:30:00	AAPL	Stock	32.8875	32.9125	32.88	32.9042	716404.0
2015-07-20 09:00:00	AAPL	Stock	32.9042	32.95	32.7425	32.7425	1439568.0
2015-07-20 09:30:00	AAPL	Stock	32.78	32.985	32.675	32.9225	40333724.0
2015-07-20 10:00:00	AAPL	Stock	32.9225	32.9725	32.7925	32.875	17641652.0
2015-07-20 10:30:00	AAPL	Stock	32.8725	32.9975	32.8675	32.9825	14593732.0
2015-07-20 11:00:00	AAPL	Stock	32.9828	33.0375	32.97	32.9888	15721420.0
2015-07-20 11:30:00	AAPL	Stock	32.9912	33.0312	32.94	33.025	10139128.0
2015-07-20 12:00:00	AAPL	Stock	33.023	33.07	33.0125	33.025	10855228.0
2015-07-20 12:30:00	AAPL	Stock	33.0252	33.05	33.0088	33.0188	7077916.0
2015-07-20 13:00:00	AAPL	Stock	33.0188	33.05	33.0125	33.0475	6987272.0
2015-07-20 13:30:00	AAPL	Stock	33.0475	33.0865	33.04	33.0475	8830188.0
2015-07-20 14:00:00	AAPL	Stock	33.045	33.1825	33.0425	33.1625	12423776.0
2015-07-20 14:30:00	AAPL	Stock	33.16	33.2075	33.1425	33.185	9874692.0
2015-07-20 15:00:00	AAPL	Stock	33.1828	33.2425	33.1625	33.1625	11841032.0
2015-07-20 15:30:00	AAPL	Stock	33.1625	33.1675	32.955	33.0175	26334068.0
2015-07-20 16:00:00	AAPL	Stock	33.0175	33.04	32.9975	33.01	5955240.0
2015-07-20 16:30:00	AAPL	Stock	33.0082	33.0672	33.0075	33.01	237196.0
2015-07-20 17:00:00	AAPL	Stock	33.0175	33.1625	33.0125	33.1	310616.0
2015-07-20 17:30:00	AAPL	Stock	33.0775	33.17	33.065	33.16	9668108.0
2015-07-20 18:00:00	AAPL	Stock	33.1625	33.1675	33.075	33.125	234500.0
2015-07-20 18:30:00	AAPL	Stock	33.125	33.14	33.115	33.125	141764.0
2015-07-20 19:00:00	AAPL	Stock	33.125	33.14	33.1125	33.13	105976.0
2015-07-20 19:30:00	AAPL	Stock	33.1208	33.1425	33.1175	33.13	127792.0
2015-07-20 07:00:00	MSFT	Stock	46.85	46.85	46.64	46.79	2760.0
2015-07-20 07:30:00	MSFT	Stock	46.59	46.7	46.59	46.7	1775.0
2015-07-20 08:00:00	MSFT	Stock	46.86	46.86	46.6	46.7	10350.0
2015-07-20 08:30:00	MSFT	Stock	46.7	46.7	46.67	46.687	7696.0
2015-07-20 09:00:00	MSFT	Stock	46.69	46.77	46.62	46.62	29227.0
2015-07-20 09:30:00	MSFT	Stock	46.64	46.77	46.44	46.51	3480703.0
2015-07-20 10:00:00	MSFT	Stock	46.5	46.65	46.47	46.595	1925063.0
2015-07-20 10:30:00	MSFT	Stock	46.59	46.64	46.53	46.611	2005169.0
2015-07-20 11:00:00	MSFT	Stock	46.614	46.77	46.59	46.75	1612341.0
2015-07-20 11:30:00	MSFT	Stock	46.76	46.83	46.685	46.81	1555244.0
2015-07-20 12:00:00	MSFT	Stock	46.81	46.86	46.71	46.715	1381630.0
2015-07-20 12:30:00	MSFT	Stock	46.711	46.78	46.63	46.64	1367160.0
2015-07-20 13:00:00	MSFT	Stock	46.64	46.87	46.62	46.865	2039680.0
2015-07-20 13:30:00	MSFT	Stock	46.86	46.885	46.8	46.815	1202853.0
2015-07-20 14:00:00	MSFT	Stock	46.815	47.06	46.81	47.044	2136294.0
2015-07-20 14:30:00	MSFT	Stock	47.04	47.13	47.03	47.04	1936479.0
2015-07-20 15:00:00	MSFT	Stock	47.04	47.08	46.98	47.0	1919286.0
2015-07-20 15:30:00	MSFT	Stock	47.0	47.02	46.89	46.92	2761211.0

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

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