PREVIEW / stock_30min / 2010-04-20

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-20.parquet
  size:    1.4 MB
  rows:    74,003
  symbols: 3,485

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
2010-04-20 04:00:00	AAPL	Stock	8.8821	8.8907	8.8821	8.89	58800.0
2010-04-20 05:00:00	AAPL	Stock	8.875	8.875	8.875	8.875	14000.0
2010-04-20 05:30:00	AAPL	Stock	8.875	8.875	8.875	8.875	22400.0
2010-04-20 06:30:00	AAPL	Stock	8.8732	8.8929	8.8732	8.8929	102536.0
2010-04-20 07:00:00	AAPL	Stock	8.8929	8.8929	8.8575	8.8639	151536.0
2010-04-20 07:30:00	AAPL	Stock	8.8679	8.8679	8.8607	8.8607	39060.0
2010-04-20 08:00:00	AAPL	Stock	8.8643	8.8739	8.8571	8.8704	1785868.0
2010-04-20 08:30:00	AAPL	Stock	8.8711	8.8764	8.8657	8.8661	1108072.0
2010-04-20 09:00:00	AAPL	Stock	8.8661	8.875	8.8239	8.8729	1406412.0
2010-04-20 09:30:00	AAPL	Stock	8.8732	8.9018	8.7543	8.7614	94229856.0
2010-04-20 10:00:00	AAPL	Stock	8.7607	8.7714	8.7179	8.7189	59996328.0
2010-04-20 10:30:00	AAPL	Stock	8.7189	8.755	8.677	8.7429	69421436.0
2010-04-20 11:00:00	AAPL	Stock	8.7421	8.7707	8.7379	8.7557	32161976.0
2010-04-20 11:30:00	AAPL	Stock	8.7559	8.7729	8.7457	8.7661	18542496.0
2010-04-20 12:00:00	AAPL	Stock	8.7664	8.8171	8.7643	8.8014	30162300.0
2010-04-20 12:30:00	AAPL	Stock	8.8011	8.8129	8.7825	8.7857	20413484.0
2010-04-20 13:00:00	AAPL	Stock	8.7854	8.8	8.7721	8.7936	17141068.0
2010-04-20 13:30:00	AAPL	Stock	8.7936	8.7944	8.7575	8.758	26088076.0
2010-04-20 14:00:00	AAPL	Stock	8.7582	8.7661	8.7232	8.76	46767252.0
2010-04-20 14:30:00	AAPL	Stock	8.7596	8.8004	8.7475	8.78	43601432.0
2010-04-20 15:00:00	AAPL	Stock	8.7804	8.7886	8.7357	8.7557	40117672.0
2010-04-20 15:30:00	AAPL	Stock	8.7554	8.775	8.7	8.7361	64707300.0
2010-04-20 16:00:00	AAPL	Stock	8.7361	8.7804	8.7086	8.7771	9232048.0
2010-04-20 16:30:00	AAPL	Stock	8.9646	9.4643	8.9561	9.3393	79678704.0
2010-04-20 17:00:00	AAPL	Stock	9.3393	9.3411	8.8072	9.2614	53281956.0
2010-04-20 17:30:00	AAPL	Stock	9.2629	9.2629	9.1786	9.2218	13384952.0
2010-04-20 18:00:00	AAPL	Stock	9.2214	9.2446	8.7354	9.2254	3594640.0
2010-04-20 18:30:00	AAPL	Stock	9.2254	9.2268	9.1821	9.1929	2676660.0
2010-04-20 19:00:00	AAPL	Stock	9.1907	9.1939	9.1821	9.1911	1338204.0
2010-04-20 19:30:00	AAPL	Stock	9.1893	9.1957	9.1825	9.1946	2258060.0
2010-04-20 20:00:00	AAPL	Stock	8.7657	8.7657	8.7657	8.7657	198800.0
2010-04-20 06:30:00	MSFT	Stock	31.12	31.12	31.12	31.12	500.0
2010-04-20 07:00:00	MSFT	Stock	31.19	31.2	31.18	31.18	1600.0
2010-04-20 07:30:00	MSFT	Stock	31.16	31.17	31.16	31.17	1300.0
2010-04-20 08:00:00	MSFT	Stock	31.17	31.2	31.1	31.19	5066.0
2010-04-20 08:30:00	MSFT	Stock	31.19	31.21	31.13	31.19	17571.0
2010-04-20 09:00:00	MSFT	Stock	31.19	31.2	31.12	31.2	131014.0
2010-04-20 09:30:00	MSFT	Stock	31.22	31.25	31.13	31.22	7395060.0
2010-04-20 10:00:00	MSFT	Stock	31.21	31.3	31.17	31.19	5661679.0
2010-04-20 10:30:00	MSFT	Stock	31.195	31.35	31.18	31.25	5885228.0
2010-04-20 11:00:00	MSFT	Stock	31.26	31.37	31.25	31.37	3174560.0
2010-04-20 11:30:00	MSFT	Stock	31.36	31.4	31.33	31.376	2579107.0
2010-04-20 12:00:00	MSFT	Stock	31.372	31.44	31.349	31.38	3186059.0
2010-04-20 12:30:00	MSFT	Stock	31.375	31.38	31.29	31.3	2251236.0
2010-04-20 13:00:00	MSFT	Stock	31.3	31.33	31.28	31.3	1225839.0
2010-04-20 13:30:00	MSFT	Stock	31.31	31.34	31.28	31.32	1772706.0
2010-04-20 14:00:00	MSFT	Stock	31.33	31.36	31.25	31.32	2101358.0
2010-04-20 14:30:00	MSFT	Stock	31.325	31.41	31.28	31.4	2485346.0
2010-04-20 15:00:00	MSFT	Stock	31.4	31.42	31.305	31.38	2386354.0
2010-04-20 15:30:00	MSFT	Stock	31.375	31.42	31.168	31.35	6182336.0

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

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