PREVIEW / stock_30min / 2015-11-02

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-02.parquet
  size:    1.6 MB
  rows:    82,707
  symbols: 3,432

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-11-02 04:00:00	AAPL	Stock	29.815	29.86	29.8125	29.86	8324.0
2015-11-02 04:30:00	AAPL	Stock	29.8725	29.905	29.8725	29.8825	15048.0
2015-11-02 05:00:00	AAPL	Stock	29.8775	29.8975	29.8775	29.8975	800.0
2015-11-02 05:30:00	AAPL	Stock	29.87	29.9025	29.87	29.9025	4000.0
2015-11-02 06:00:00	AAPL	Stock	29.89	29.9	29.875	29.9	49200.0
2015-11-02 06:30:00	AAPL	Stock	29.9	29.91	29.875	29.875	23620.0
2015-11-02 07:00:00	AAPL	Stock	29.875	29.925	29.8475	29.9175	71300.0
2015-11-02 07:30:00	AAPL	Stock	29.9125	29.935	29.8975	29.935	40856.0
2015-11-02 08:00:00	AAPL	Stock	29.92	29.9625	29.8625	29.9625	221608.0
2015-11-02 08:30:00	AAPL	Stock	29.9625	29.965	29.93	29.9575	202116.0
2015-11-02 09:00:00	AAPL	Stock	29.9575	29.9675	29.875	29.965	327124.0
2015-11-02 09:30:00	AAPL	Stock	29.9675	30.0875	29.9025	30.05	19477300.0
2015-11-02 10:00:00	AAPL	Stock	30.0675	30.22	30.02	30.1975	14248328.0
2015-11-02 10:30:00	AAPL	Stock	30.1952	30.2375	30.1475	30.2338	9868600.0
2015-11-02 11:00:00	AAPL	Stock	30.235	30.2625	30.17	30.195	10301400.0
2015-11-02 11:30:00	AAPL	Stock	30.1952	30.2475	30.16	30.2262	7243144.0
2015-11-02 12:00:00	AAPL	Stock	30.225	30.25	30.1875	30.2235	4588936.0
2015-11-02 12:30:00	AAPL	Stock	30.225	30.245	30.175	30.2212	5256900.0
2015-11-02 13:00:00	AAPL	Stock	30.2225	30.2325	30.1925	30.225	3646708.0
2015-11-02 13:30:00	AAPL	Stock	30.2238	30.24	30.2	30.235	4444972.0
2015-11-02 14:00:00	AAPL	Stock	30.235	30.245	30.205	30.2302	4891156.0
2015-11-02 14:30:00	AAPL	Stock	30.2325	30.2375	30.185	30.2275	6236488.0
2015-11-02 15:00:00	AAPL	Stock	30.2275	30.3125	30.2025	30.2875	9305336.0
2015-11-02 15:30:00	AAPL	Stock	30.2875	30.34	30.25	30.2975	13103644.0
2015-11-02 16:00:00	AAPL	Stock	30.29	30.315	30.2625	30.285	4171100.0
2015-11-02 16:30:00	AAPL	Stock	30.2875	30.2875	30.2625	30.2625	93248.0
2015-11-02 17:00:00	AAPL	Stock	30.265	30.295	30.265	30.2875	365528.0
2015-11-02 17:30:00	AAPL	Stock	30.2875	30.2875	30.275	30.285	6936.0
2015-11-02 18:00:00	AAPL	Stock	30.2825	30.2825	30.2625	30.275	24756.0
2015-11-02 18:30:00	AAPL	Stock	30.275	30.275	30.2625	30.265	28800.0
2015-11-02 19:00:00	AAPL	Stock	30.265	30.2775	30.2625	30.2625	33812.0
2015-11-02 19:30:00	AAPL	Stock	30.275	30.3125	30.265	30.3125	44792.0
2015-11-02 05:00:00	MSFT	Stock	52.65	52.65	52.65	52.65	200.0
2015-11-02 05:30:00	MSFT	Stock	52.74	52.74	52.74	52.74	100.0
2015-11-02 06:00:00	MSFT	Stock	52.66	52.66	52.66	52.66	100.0
2015-11-02 07:00:00	MSFT	Stock	52.7	52.7	52.7	52.7	400.0
2015-11-02 07:30:00	MSFT	Stock	52.85	52.85	52.73	52.8	2445.0
2015-11-02 08:00:00	MSFT	Stock	52.8	52.8	52.75	52.75	200.0
2015-11-02 08:30:00	MSFT	Stock	52.76	52.85	52.75	52.82	9090.0
2015-11-02 09:00:00	MSFT	Stock	52.64	52.82	52.64	52.8	15163.0
2015-11-02 09:30:00	MSFT	Stock	52.85	52.98	52.62	52.96	2537877.0
2015-11-02 10:00:00	MSFT	Stock	52.97	53.15	52.89	53.12	1694991.0
2015-11-02 10:30:00	MSFT	Stock	53.125	53.14	52.93	52.946	2438832.0
2015-11-02 11:00:00	MSFT	Stock	52.945	53.01	52.87	52.91	1929430.0
2015-11-02 11:30:00	MSFT	Stock	52.915	52.99	52.89	52.98	1653978.0
2015-11-02 12:00:00	MSFT	Stock	52.975	52.99	52.92	52.97	1467186.0
2015-11-02 12:30:00	MSFT	Stock	52.98	53.31	52.94	53.224	2346031.0
2015-11-02 13:00:00	MSFT	Stock	53.23	53.265	53.12	53.15	1197379.0
2015-11-02 13:30:00	MSFT	Stock	53.15	53.17	53.08	53.12	1283676.0
2015-11-02 14:00:00	MSFT	Stock	53.12	53.27	53.11	53.195	1236041.0

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

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