PREVIEW / stock_30min / 2012-09-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-17.parquet
  size:    1.4 MB
  rows:    74,928
  symbols: 3,458

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
2012-09-17 04:00:00	AAPL	Stock	24.7857	24.7857	24.7679	24.7857	29400.0
2012-09-17 04:30:00	AAPL	Stock	24.7643	24.795	24.7643	24.795	9772.0
2012-09-17 05:30:00	AAPL	Stock	24.7679	24.7679	24.7679	24.7679	2800.0
2012-09-17 06:00:00	AAPL	Stock	24.8068	24.8068	24.7857	24.7857	14784.0
2012-09-17 06:30:00	AAPL	Stock	24.7925	24.8036	24.7925	24.7929	83972.0
2012-09-17 07:00:00	AAPL	Stock	24.7857	24.85	24.7786	24.8357	616728.0
2012-09-17 07:30:00	AAPL	Stock	24.83	24.8332	24.7682	24.8032	280028.0
2012-09-17 08:00:00	AAPL	Stock	24.7989	24.8571	24.78	24.8532	1803620.0
2012-09-17 08:30:00	AAPL	Stock	24.8504	24.9118	24.8486	24.8957	3881388.0
2012-09-17 09:00:00	AAPL	Stock	24.8964	24.9939	24.8829	24.9771	5502084.0
2012-09-17 09:30:00	AAPL	Stock	24.9768	24.9836	24.8089	24.8389	78038772.0
2012-09-17 10:00:00	AAPL	Stock	24.8367	24.9493	24.8289	24.925	35222124.0
2012-09-17 10:30:00	AAPL	Stock	24.9271	24.9704	24.9054	24.9671	25640496.0
2012-09-17 11:00:00	AAPL	Stock	24.9671	24.9718	24.9104	24.9225	23523360.0
2012-09-17 11:30:00	AAPL	Stock	24.9229	24.9464	24.9214	24.9357	12055708.0
2012-09-17 12:00:00	AAPL	Stock	24.935	24.9657	24.9286	24.9564	13313776.0
2012-09-17 12:30:00	AAPL	Stock	24.9561	24.9596	24.9314	24.9379	7648256.0
2012-09-17 13:00:00	AAPL	Stock	24.9361	24.9429	24.8886	24.9043	15229284.0
2012-09-17 13:30:00	AAPL	Stock	24.9054	24.9079	24.8636	24.8736	15635116.0
2012-09-17 14:00:00	AAPL	Stock	24.8715	24.8821	24.8075	24.8739	25278232.0
2012-09-17 14:30:00	AAPL	Stock	24.8718	24.9318	24.8711	24.9146	18312588.0
2012-09-17 15:00:00	AAPL	Stock	24.9129	24.9157	24.8464	24.8664	20904184.0
2012-09-17 15:30:00	AAPL	Stock	24.8689	24.9929	24.8671	24.9929	49043568.0
2012-09-17 16:00:00	AAPL	Stock	24.9929	25.0157	24.9153	25.0036	24196340.0
2012-09-17 16:30:00	AAPL	Stock	25.0018	25.0057	24.8661	24.995	1585332.0
2012-09-17 17:00:00	AAPL	Stock	24.9964	25.0246	24.9921	25.0186	2615704.0
2012-09-17 17:30:00	AAPL	Stock	25.0211	25.0639	25.02	25.0514	694260.0
2012-09-17 18:00:00	AAPL	Stock	25.05	25.0518	25.0246	25.0318	544964.0
2012-09-17 18:30:00	AAPL	Stock	25.0232	25.0482	25.0221	25.0393	444500.0
2012-09-17 19:00:00	AAPL	Stock	25.0357	25.0571	25.0357	25.0571	125860.0
2012-09-17 19:30:00	AAPL	Stock	25.0607	25.0714	25.0532	25.0679	510692.0
2012-09-17 04:30:00	MSFT	Stock	31.02	31.09	31.02	31.09	300.0
2012-09-17 05:30:00	MSFT	Stock	31.38	31.38	31.32	31.32	200.0
2012-09-17 06:00:00	MSFT	Stock	31.5	31.5	31.5	31.5	200.0
2012-09-17 06:30:00	MSFT	Stock	31.21	31.21	31.21	31.21	100.0
2012-09-17 07:00:00	MSFT	Stock	31.2	31.2	31.19	31.19	300.0
2012-09-17 07:30:00	MSFT	Stock	31.2	31.24	31.2	31.24	500.0
2012-09-17 08:00:00	MSFT	Stock	31.15	31.2	31.1	31.2	1051.0
2012-09-17 08:30:00	MSFT	Stock	31.1	31.16	31.1	31.16	725.0
2012-09-17 09:00:00	MSFT	Stock	31.19	31.2	31.06	31.2	32154.0
2012-09-17 09:30:00	MSFT	Stock	31.19	31.26	31.04	31.12	3099560.0
2012-09-17 10:00:00	MSFT	Stock	31.12	31.22	31.06	31.18	4529046.0
2012-09-17 10:30:00	MSFT	Stock	31.19	31.19	31.09	31.115	2225600.0
2012-09-17 11:00:00	MSFT	Stock	31.11	31.16	31.08	31.1	1660886.0
2012-09-17 11:30:00	MSFT	Stock	31.1	31.16	31.09	31.15	2209076.0
2012-09-17 12:00:00	MSFT	Stock	31.14	31.175	31.135	31.16	1560818.0
2012-09-17 12:30:00	MSFT	Stock	31.155	31.17	31.11	31.12	1013442.0
2012-09-17 13:00:00	MSFT	Stock	31.12	31.19	31.1	31.18	1219950.0
2012-09-17 13:30:00	MSFT	Stock	31.18	31.2	31.15	31.166	960378.0
2012-09-17 14:00:00	MSFT	Stock	31.17	31.17	31.09	31.13	2277525.0

> showing 50 of 74,928 rows — these rows as CSV

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