PREVIEW / stock_30min / 2010-04-13

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-13.parquet
  size:    1.4 MB
  rows:    74,112
  symbols: 3,477

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-13 05:30:00	AAPL	Stock	8.6357	8.6357	8.6357	8.6357	3136.0
2010-04-13 06:30:00	AAPL	Stock	8.65	8.65	8.65	8.65	5264.0
2010-04-13 07:30:00	AAPL	Stock	8.6321	8.6464	8.6071	8.6464	79800.0
2010-04-13 08:00:00	AAPL	Stock	8.6504	8.6509	8.6318	8.6371	487984.0
2010-04-13 08:30:00	AAPL	Stock	8.6371	8.6454	8.6368	8.6432	620172.0
2010-04-13 09:00:00	AAPL	Stock	8.6414	8.6461	8.6286	8.6393	750708.0
2010-04-13 09:30:00	AAPL	Stock	8.6389	8.6714	8.6368	8.6586	51500820.0
2010-04-13 10:00:00	AAPL	Stock	8.6586	8.6671	8.6289	8.6311	40419736.0
2010-04-13 10:30:00	AAPL	Stock	8.6311	8.6556	8.6111	8.6279	33248348.0
2010-04-13 11:00:00	AAPL	Stock	8.6282	8.6446	8.6129	8.6418	22110508.0
2010-04-13 11:30:00	AAPL	Stock	8.6425	8.6464	8.6296	8.6371	10123764.0
2010-04-13 12:00:00	AAPL	Stock	8.6379	8.64	8.6221	8.6381	14526092.0
2010-04-13 12:30:00	AAPL	Stock	8.6368	8.6514	8.6332	8.6496	8656452.0
2010-04-13 13:00:00	AAPL	Stock	8.6496	8.6618	8.6475	8.6485	18560052.0
2010-04-13 13:30:00	AAPL	Stock	8.6489	8.6696	8.6468	8.6679	15372056.0
2010-04-13 14:00:00	AAPL	Stock	8.6672	8.6696	8.6596	8.66	13036660.0
2010-04-13 14:30:00	AAPL	Stock	8.6604	8.6639	8.6529	8.6536	13158908.0
2010-04-13 15:00:00	AAPL	Stock	8.6536	8.6661	8.6514	8.6604	18788560.0
2010-04-13 15:30:00	AAPL	Stock	8.6604	8.6636	8.6464	8.655	31643892.0
2010-04-13 16:00:00	AAPL	Stock	8.655	8.6875	8.6441	8.6821	6716696.0
2010-04-13 16:30:00	AAPL	Stock	8.6786	8.6796	8.63	8.6732	1822912.0
2010-04-13 17:00:00	AAPL	Stock	8.6732	8.6757	8.6679	8.6746	258776.0
2010-04-13 17:30:00	AAPL	Stock	8.6732	8.6771	8.6481	8.6771	285432.0
2010-04-13 18:00:00	AAPL	Stock	8.6775	8.6904	8.6775	8.6829	703808.0
2010-04-13 18:30:00	AAPL	Stock	8.6854	8.6889	8.675	8.6825	214284.0
2010-04-13 19:00:00	AAPL	Stock	8.6857	8.6857	8.6825	8.6854	82124.0
2010-04-13 19:30:00	AAPL	Stock	8.6839	8.6893	8.6839	8.6875	185360.0
2010-04-13 08:00:00	MSFT	Stock	30.34	30.34	30.21	30.33	3565.0
2010-04-13 08:30:00	MSFT	Stock	30.26	30.26	30.26	30.26	1116.0
2010-04-13 09:00:00	MSFT	Stock	30.26	30.29	30.15	30.15	44928.0
2010-04-13 09:30:00	MSFT	Stock	30.15	30.34	30.13	30.27	4941902.0
2010-04-13 10:00:00	MSFT	Stock	30.26	30.3	30.21	30.275	3339021.0
2010-04-13 10:30:00	MSFT	Stock	30.275	30.36	30.17	30.32	3411479.0
2010-04-13 11:00:00	MSFT	Stock	30.32	30.35	30.27	30.315	1957517.0
2010-04-13 11:30:00	MSFT	Stock	30.31	30.34	30.28	30.295	3673294.0
2010-04-13 12:00:00	MSFT	Stock	30.292	30.36	30.27	30.32	1712396.0
2010-04-13 12:30:00	MSFT	Stock	30.32	30.34	30.27	30.31	1265434.0
2010-04-13 13:00:00	MSFT	Stock	30.315	30.35	30.3	30.3	1705393.0
2010-04-13 13:30:00	MSFT	Stock	30.3	30.45	30.3	30.42	2026413.0
2010-04-13 14:00:00	MSFT	Stock	30.422	30.48	30.4	30.45	1869008.0
2010-04-13 14:30:00	MSFT	Stock	30.45	30.49	30.44	30.485	2529924.0
2010-04-13 15:00:00	MSFT	Stock	30.48	30.5	30.44	30.485	3921309.0
2010-04-13 15:30:00	MSFT	Stock	30.49	30.5	30.42	30.45	4837673.0
2010-04-13 16:00:00	MSFT	Stock	30.45	30.82	30.349	30.8	2195415.0
2010-04-13 16:30:00	MSFT	Stock	30.8	30.95	30.28	30.88	1352162.0
2010-04-13 17:00:00	MSFT	Stock	30.88	30.88	30.83	30.88	13362.0
2010-04-13 17:30:00	MSFT	Stock	30.88	30.88	30.79	30.82	12686.0
2010-04-13 18:00:00	MSFT	Stock	30.82	30.87	30.45	30.84	1848.0
2010-04-13 18:30:00	MSFT	Stock	30.8	30.8	30.72	30.76	15279.0
2010-04-13 19:30:00	MSFT	Stock	30.76	30.78	30.76	30.78	1340.0

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

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