PREVIEW / stock_30min / 2016-08-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-12.parquet
  size:    1.6 MB
  rows:    80,782
  symbols: 3,245

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-12 04:00:00	AAPL	Stock	27.03	27.0425	27.03	27.0425	4636.0
2016-08-12 04:30:00	AAPL	Stock	27.0175	27.0175	27.0175	27.0175	800.0
2016-08-12 05:30:00	AAPL	Stock	27.0225	27.0225	27.0225	27.0225	400.0
2016-08-12 06:30:00	AAPL	Stock	27.025	27.025	27.025	27.025	400.0
2016-08-12 07:00:00	AAPL	Stock	27.025	27.025	27.0	27.0	1992.0
2016-08-12 07:30:00	AAPL	Stock	27.025	27.025	27.025	27.025	8800.0
2016-08-12 08:00:00	AAPL	Stock	27.0425	27.05	27.0025	27.04	75536.0
2016-08-12 08:30:00	AAPL	Stock	27.05	27.055	27.04	27.04	195412.0
2016-08-12 09:00:00	AAPL	Stock	27.0425	27.05	26.945	26.95	652536.0
2016-08-12 09:30:00	AAPL	Stock	26.945	27.1	26.9425	27.055	13840884.0
2016-08-12 10:00:00	AAPL	Stock	27.0562	27.075	27.005	27.06	6432944.0
2016-08-12 10:30:00	AAPL	Stock	27.0612	27.11	27.035	27.095	5694804.0
2016-08-12 11:00:00	AAPL	Stock	27.095	27.0975	27.05	27.07	3586792.0
2016-08-12 11:30:00	AAPL	Stock	27.07	27.075	26.9725	26.9925	4119628.0
2016-08-12 12:00:00	AAPL	Stock	26.993	27.0225	26.985	27.01	3523960.0
2016-08-12 12:30:00	AAPL	Stock	27.01	27.03	26.9925	26.9962	3376748.0
2016-08-12 13:00:00	AAPL	Stock	26.9975	27.005	26.95	26.9775	3855896.0
2016-08-12 13:30:00	AAPL	Stock	26.9775	26.995	26.9675	26.981	2197940.0
2016-08-12 14:00:00	AAPL	Stock	26.9802	27.0125	26.975	26.9925	2891300.0
2016-08-12 14:30:00	AAPL	Stock	26.9925	27.034	26.9925	27.0305	3387632.0
2016-08-12 15:00:00	AAPL	Stock	27.03	27.05	27.03	27.0462	3352900.0
2016-08-12 15:30:00	AAPL	Stock	27.0475	27.0525	27.0275	27.04	7713988.0
2016-08-12 16:00:00	AAPL	Stock	27.045	27.0475	27.025	27.0475	3842368.0
2016-08-12 16:30:00	AAPL	Stock	27.05	27.05	27.03	27.0375	30000.0
2016-08-12 17:00:00	AAPL	Stock	27.0375	27.0375	27.03	27.03	19996.0
2016-08-12 17:30:00	AAPL	Stock	27.03	27.0375	27.03	27.035	2000.0
2016-08-12 18:00:00	AAPL	Stock	27.0325	27.0325	27.0175	27.0175	22940.0
2016-08-12 19:00:00	AAPL	Stock	27.0275	27.0275	27.015	27.025	3400.0
2016-08-12 19:30:00	AAPL	Stock	27.025	27.03	27.025	27.0275	8540.0
2016-08-12 06:00:00	MSFT	Stock	58.16	58.16	58.16	58.16	100.0
2016-08-12 08:30:00	MSFT	Stock	58.3	58.3	58.21	58.21	1100.0
2016-08-12 09:00:00	MSFT	Stock	58.21	58.21	58.03	58.04	85808.0
2016-08-12 09:30:00	MSFT	Stock	58.03	58.19	57.7	57.722	3065884.0
2016-08-12 10:00:00	MSFT	Stock	57.73	57.91	57.71	57.72	1700818.0
2016-08-12 10:30:00	MSFT	Stock	57.725	57.835	57.71	57.827	1429735.0
2016-08-12 11:00:00	MSFT	Stock	57.825	57.88	57.7	57.72	1280840.0
2016-08-12 11:30:00	MSFT	Stock	57.72	57.77	57.62	57.72	1273154.0
2016-08-12 12:00:00	MSFT	Stock	57.73	57.75	57.66	57.7	915626.0
2016-08-12 12:30:00	MSFT	Stock	57.71	57.78	57.69	57.74	870052.0
2016-08-12 13:00:00	MSFT	Stock	57.745	57.8	57.63	57.77	1100593.0
2016-08-12 13:30:00	MSFT	Stock	57.774	57.835	57.72	57.72	1010410.0
2016-08-12 14:00:00	MSFT	Stock	57.73	57.79	57.685	57.77	793566.0
2016-08-12 14:30:00	MSFT	Stock	57.774	57.835	57.76	57.785	1116825.0
2016-08-12 15:00:00	MSFT	Stock	57.79	57.81	57.75	57.805	1042047.0
2016-08-12 15:30:00	MSFT	Stock	57.8	57.94	57.79	57.94	2890038.0
2016-08-12 16:00:00	MSFT	Stock	57.94	57.94	57.87	57.89	1671639.0
2016-08-12 16:30:00	MSFT	Stock	57.93	57.93	57.93	57.93	500.0
2016-08-12 17:00:00	MSFT	Stock	57.91	57.91	57.9	57.9	1650.0
2016-08-12 17:30:00	MSFT	Stock	57.91	57.91	57.91	57.91	129.0
2016-08-12 18:00:00	MSFT	Stock	57.92	57.92	57.92	57.92	100.0

> showing 50 of 80,782 rows — these rows as CSV

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