PREVIEW / stock_30min / 2014-03-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-17.parquet
  size:    1.6 MB
  rows:    83,291
  symbols: 3,544

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-03-17 04:00:00	AAPL	Stock	18.795	18.7961	18.795	18.7961	14000.0
2014-03-17 05:00:00	AAPL	Stock	18.8646	18.8814	18.8646	18.8814	5600.0
2014-03-17 06:00:00	AAPL	Stock	18.8482	18.8482	18.8279	18.8279	5600.0
2014-03-17 06:30:00	AAPL	Stock	18.8471	18.8536	18.8471	18.8536	14000.0
2014-03-17 07:00:00	AAPL	Stock	18.8304	18.8757	18.8304	18.85	95732.0
2014-03-17 07:30:00	AAPL	Stock	18.8529	18.8561	18.8393	18.8393	46564.0
2014-03-17 08:00:00	AAPL	Stock	18.8421	18.8857	18.8275	18.8654	816340.0
2014-03-17 08:30:00	AAPL	Stock	18.8732	18.8746	18.8357	18.8357	373408.0
2014-03-17 09:00:00	AAPL	Stock	18.8336	18.8564	18.8279	18.8468	422996.0
2014-03-17 09:30:00	AAPL	Stock	18.8304	18.9275	18.8112	18.8718	31848152.0
2014-03-17 10:00:00	AAPL	Stock	18.8704	18.9105	18.8236	18.833	15422456.0
2014-03-17 10:30:00	AAPL	Stock	18.8329	18.85	18.7804	18.8314	15011612.0
2014-03-17 11:00:00	AAPL	Stock	18.8311	18.8732	18.8264	18.8593	7640556.0
2014-03-17 11:30:00	AAPL	Stock	18.8593	18.8929	18.8361	18.8861	7965692.0
2014-03-17 12:00:00	AAPL	Stock	18.8879	18.9236	18.8732	18.9193	7637280.0
2014-03-17 12:30:00	AAPL	Stock	18.9205	18.9257	18.9025	18.9096	7553084.0
2014-03-17 13:00:00	AAPL	Stock	18.9104	18.9168	18.8682	18.9018	6700092.0
2014-03-17 13:30:00	AAPL	Stock	18.9028	18.9104	18.8864	18.8939	5077492.0
2014-03-17 14:00:00	AAPL	Stock	18.8918	18.8946	18.8368	18.8657	7892416.0
2014-03-17 14:30:00	AAPL	Stock	18.8621	18.8711	18.8371	18.86	4835488.0
2014-03-17 15:00:00	AAPL	Stock	18.8607	18.8689	18.8411	18.8461	5562620.0
2014-03-17 15:30:00	AAPL	Stock	18.8443	18.8495	18.7875	18.8189	20593776.0
2014-03-17 16:00:00	AAPL	Stock	18.8121	18.9192	18.7986	18.8089	14461748.0
2014-03-17 16:30:00	AAPL	Stock	18.8125	18.8143	18.8036	18.8104	47936.0
2014-03-17 17:00:00	AAPL	Stock	18.8143	18.8268	18.8046	18.8054	227248.0
2014-03-17 17:30:00	AAPL	Stock	18.8154	18.8214	18.8121	18.8143	215460.0
2014-03-17 18:00:00	AAPL	Stock	18.8121	18.8129	18.8057	18.8129	79492.0
2014-03-17 18:30:00	AAPL	Stock	18.8143	18.8214	18.8121	18.8214	35784.0
2014-03-17 19:00:00	AAPL	Stock	18.8189	18.8189	18.8189	18.8189	4256.0
2014-03-17 19:30:00	AAPL	Stock	18.8129	18.8129	18.7893	18.8	167832.0
2014-03-17 07:00:00	MSFT	Stock	37.85	37.98	37.85	37.98	500.0
2014-03-17 08:00:00	MSFT	Stock	37.9	37.9	37.88	37.88	279.0
2014-03-17 08:30:00	MSFT	Stock	37.88	37.93	37.88	37.92	2066.0
2014-03-17 09:00:00	MSFT	Stock	37.93	37.93	37.76	37.83	18234.0
2014-03-17 09:30:00	MSFT	Stock	37.9	38.31	37.79	38.3	2445248.0
2014-03-17 10:00:00	MSFT	Stock	38.3	38.41	38.19	38.25	2361933.0
2014-03-17 10:30:00	MSFT	Stock	38.25	38.3	38.11	38.14	1651271.0
2014-03-17 11:00:00	MSFT	Stock	38.13	38.2	38.06	38.07	933102.0
2014-03-17 11:30:00	MSFT	Stock	38.065	38.07	37.94	38.05	848023.0
2014-03-17 12:00:00	MSFT	Stock	38.05	38.21	38.013	38.21	770620.0
2014-03-17 12:30:00	MSFT	Stock	38.22	38.25	38.08	38.14	853796.0
2014-03-17 13:00:00	MSFT	Stock	38.143	38.19	38.135	38.16	597635.0
2014-03-17 13:30:00	MSFT	Stock	38.16	38.22	38.14	38.185	544929.0
2014-03-17 14:00:00	MSFT	Stock	38.19	38.265	38.155	38.235	734946.0
2014-03-17 14:30:00	MSFT	Stock	38.23	38.24	38.16	38.195	600804.0
2014-03-17 15:00:00	MSFT	Stock	38.19	38.2	38.16	38.18	812755.0
2014-03-17 15:30:00	MSFT	Stock	38.175	38.2	38.01	38.04	4569163.0
2014-03-17 16:00:00	MSFT	Stock	38.05	38.153	38.004	38.05	1968061.0
2014-03-17 16:30:00	MSFT	Stock	38.05	38.127	38.05	38.127	18748.0
2014-03-17 17:00:00	MSFT	Stock	38.05	38.05	38.05	38.05	200.0

> showing 50 of 83,291 rows — these rows as CSV

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