PREVIEW / stock_30min / 2016-08-10

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-10.parquet
  size:    1.6 MB
  rows:    82,205
  symbols: 3,266

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
2016-08-10 04:00:00	AAPL	Stock	27.1675	27.1675	27.1625	27.1625	1112.0
2016-08-10 04:30:00	AAPL	Stock	27.1925	27.1925	27.165	27.1675	4704.0
2016-08-10 05:00:00	AAPL	Stock	27.1625	27.185	27.1625	27.185	1580.0
2016-08-10 05:30:00	AAPL	Stock	27.175	27.175	27.1725	27.1725	2608.0
2016-08-10 06:00:00	AAPL	Stock	27.1725	27.1725	27.1725	27.1725	1240.0
2016-08-10 06:30:00	AAPL	Stock	27.155	27.155	27.1325	27.1325	4796.0
2016-08-10 07:00:00	AAPL	Stock	27.15	27.2025	27.15	27.16	16000.0
2016-08-10 07:30:00	AAPL	Stock	27.165	27.2125	27.165	27.2	12104.0
2016-08-10 08:00:00	AAPL	Stock	27.21	27.225	27.1325	27.2175	83448.0
2016-08-10 08:30:00	AAPL	Stock	27.2175	27.2225	27.2	27.205	87132.0
2016-08-10 09:00:00	AAPL	Stock	27.2075	27.2325	27.16	27.16	364276.0
2016-08-10 09:30:00	AAPL	Stock	27.16	27.225	27.1	27.1025	12438352.0
2016-08-10 10:00:00	AAPL	Stock	27.1025	27.14	27.0825	27.0838	9292772.0
2016-08-10 10:30:00	AAPL	Stock	27.085	27.0975	27.0625	27.075	6291924.0
2016-08-10 11:00:00	AAPL	Stock	27.0755	27.0975	27.0062	27.01	7625572.0
2016-08-10 11:30:00	AAPL	Stock	27.0102	27.0125	26.94	26.99	7418728.0
2016-08-10 12:00:00	AAPL	Stock	26.99	27.02	26.9825	27.0092	4941052.0
2016-08-10 12:30:00	AAPL	Stock	27.0075	27.01	26.9675	27.0	3447368.0
2016-08-10 13:00:00	AAPL	Stock	27.0018	27.06	26.99	27.0562	4426516.0
2016-08-10 13:30:00	AAPL	Stock	27.055	27.0575	27.0275	27.0275	2759632.0
2016-08-10 14:00:00	AAPL	Stock	27.0275	27.04	26.9875	26.9935	3891764.0
2016-08-10 14:30:00	AAPL	Stock	26.9938	26.9975	26.9525	26.9538	5466188.0
2016-08-10 15:00:00	AAPL	Stock	26.9525	27.03	26.9475	26.956	6393116.0
2016-08-10 15:30:00	AAPL	Stock	26.9562	27.01	26.955	27.0	9746732.0
2016-08-10 16:00:00	AAPL	Stock	27.0	27.0125	26.9875	27.01	3455852.0
2016-08-10 16:30:00	AAPL	Stock	26.99	27.0	26.99	27.0	4548.0
2016-08-10 17:00:00	AAPL	Stock	27.0	27.0	26.995	26.995	96408.0
2016-08-10 17:30:00	AAPL	Stock	27.0	27.0	26.9875	26.9975	103384.0
2016-08-10 18:00:00	AAPL	Stock	26.9975	26.9975	26.9625	26.97	8000.0
2016-08-10 18:30:00	AAPL	Stock	26.9675	26.99	26.965	26.9675	24036.0
2016-08-10 19:00:00	AAPL	Stock	26.9775	26.9775	26.975	26.975	1300.0
2016-08-10 19:30:00	AAPL	Stock	26.9825	26.985	26.9675	26.97	11560.0
2016-08-10 05:30:00	MSFT	Stock	58.23	58.23	58.23	58.23	200.0
2016-08-10 07:00:00	MSFT	Stock	58.19	58.19	58.19	58.19	1175.0
2016-08-10 07:30:00	MSFT	Stock	58.22	58.22	58.22	58.22	200.0
2016-08-10 08:00:00	MSFT	Stock	58.23	58.35	58.21	58.35	1090.0
2016-08-10 08:30:00	MSFT	Stock	58.35	58.35	58.35	58.35	1800.0
2016-08-10 09:00:00	MSFT	Stock	58.23	58.23	58.09	58.09	71820.0
2016-08-10 09:30:00	MSFT	Stock	58.15	58.26	57.82	58.045	2433752.0
2016-08-10 10:00:00	MSFT	Stock	58.05	58.32	58.045	58.211	906918.0
2016-08-10 10:30:00	MSFT	Stock	58.215	58.25	58.15	58.165	581341.0
2016-08-10 11:00:00	MSFT	Stock	58.17	58.24	57.88	57.93	1111915.0
2016-08-10 11:30:00	MSFT	Stock	57.93	57.96	57.89	57.93	1025303.0
2016-08-10 12:00:00	MSFT	Stock	57.92	58.0	57.865	57.9	811361.0
2016-08-10 12:30:00	MSFT	Stock	57.91	58.04	57.906	58.015	652999.0
2016-08-10 13:00:00	MSFT	Stock	58.02	58.04	57.89	57.9	616659.0
2016-08-10 13:30:00	MSFT	Stock	57.9	58.0	57.89	57.97	625116.0
2016-08-10 14:00:00	MSFT	Stock	57.97	58.02	57.875	57.89	763666.0
2016-08-10 14:30:00	MSFT	Stock	57.887	57.91	57.83	57.876	963124.0
2016-08-10 15:00:00	MSFT	Stock	57.88	57.98	57.834	57.95	1529346.0

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

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