PREVIEW / stock_30min / 2011-04-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-15.parquet
  size:    1.4 MB
  rows:    77,157
  symbols: 3,530

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
2011-04-15 04:30:00	AAPL	Stock	11.8736	11.8736	11.8736	11.8736	2800.0
2011-04-15 05:00:00	AAPL	Stock	11.8993	11.8993	11.8993	11.8993	2800.0
2011-04-15 05:30:00	AAPL	Stock	11.8929	11.8929	11.8714	11.8714	47180.0
2011-04-15 06:00:00	AAPL	Stock	11.8714	11.8714	11.8714	11.8714	2800.0
2011-04-15 06:30:00	AAPL	Stock	11.8714	11.8714	11.8714	11.8714	8400.0
2011-04-15 07:00:00	AAPL	Stock	11.8468	11.8711	11.8464	11.8711	64400.0
2011-04-15 07:30:00	AAPL	Stock	11.8707	11.8711	11.8607	11.8704	53452.0
2011-04-15 08:00:00	AAPL	Stock	11.8611	11.8611	11.8179	11.8179	460404.0
2011-04-15 08:30:00	AAPL	Stock	11.8189	11.8596	11.8189	11.8554	526372.0
2011-04-15 09:00:00	AAPL	Stock	11.8536	11.9189	11.8536	11.9089	3223136.0
2011-04-15 09:30:00	AAPL	Stock	11.9089	11.9157	11.755	11.7932	86136820.0
2011-04-15 10:00:00	AAPL	Stock	11.7939	11.8193	11.7846	11.7911	36003072.0
2011-04-15 10:30:00	AAPL	Stock	11.7925	11.8143	11.78	11.8043	30735880.0
2011-04-15 11:00:00	AAPL	Stock	11.8046	11.8425	11.8043	11.8379	23131472.0
2011-04-15 11:30:00	AAPL	Stock	11.8379	11.8529	11.8161	11.8187	19221132.0
2011-04-15 12:00:00	AAPL	Stock	11.8176	11.8257	11.8039	11.8107	13431628.0
2011-04-15 12:30:00	AAPL	Stock	11.81	11.8257	11.8079	11.8218	12479572.0
2011-04-15 13:00:00	AAPL	Stock	11.8243	11.8289	11.7961	11.7991	9480072.0
2011-04-15 13:30:00	AAPL	Stock	11.7989	11.8	11.7893	11.7907	12310732.0
2011-04-15 14:00:00	AAPL	Stock	11.7895	11.7954	11.7857	11.7925	15197420.0
2011-04-15 14:30:00	AAPL	Stock	11.7925	11.7943	11.7614	11.7654	22568952.0
2011-04-15 15:00:00	AAPL	Stock	11.765	11.765	11.7075	11.7143	47559036.0
2011-04-15 15:30:00	AAPL	Stock	11.7157	11.73	11.6714	11.6957	67373796.0
2011-04-15 16:00:00	AAPL	Stock	11.6979	11.7903	11.6895	11.7075	8917524.0
2011-04-15 16:30:00	AAPL	Stock	11.7086	11.8211	11.695	11.7021	1861916.0
2011-04-15 17:00:00	AAPL	Stock	11.6986	11.7071	11.6982	11.6989	325780.0
2011-04-15 17:30:00	AAPL	Stock	11.7054	11.7086	11.6982	11.7086	102284.0
2011-04-15 18:00:00	AAPL	Stock	11.695	11.7089	11.695	11.7089	222600.0
2011-04-15 18:30:00	AAPL	Stock	11.7107	11.7246	11.7107	11.7211	125356.0
2011-04-15 19:00:00	AAPL	Stock	11.7232	11.7232	11.7164	11.7229	40488.0
2011-04-15 19:30:00	AAPL	Stock	11.7179	11.7286	11.7179	11.7286	115920.0
2011-04-15 06:00:00	MSFT	Stock	25.44	25.44	25.44	25.44	100.0
2011-04-15 07:30:00	MSFT	Stock	25.42	25.42	25.42	25.42	1400.0
2011-04-15 08:00:00	MSFT	Stock	25.38	25.4	25.35	25.4	4408.0
2011-04-15 08:30:00	MSFT	Stock	25.37	25.38	25.36	25.38	2858.0
2011-04-15 09:00:00	MSFT	Stock	25.4	25.52	25.37	25.48	183081.0
2011-04-15 09:30:00	MSFT	Stock	25.47	25.56	25.28	25.36	10584960.0
2011-04-15 10:00:00	MSFT	Stock	25.36	25.43	25.25	25.272	3089876.0
2011-04-15 10:30:00	MSFT	Stock	25.27	25.32	25.22	25.22	2992416.0
2011-04-15 11:00:00	MSFT	Stock	25.22	25.24	25.18	25.21	3763760.0
2011-04-15 11:30:00	MSFT	Stock	25.21	25.25	25.2	25.225	2193459.0
2011-04-15 12:00:00	MSFT	Stock	25.225	25.285	25.19	25.26	3735850.0
2011-04-15 12:30:00	MSFT	Stock	25.265	25.29	25.25	25.27	2575320.0
2011-04-15 13:00:00	MSFT	Stock	25.27	25.29	25.24	25.25	2401825.0
2011-04-15 13:30:00	MSFT	Stock	25.255	25.36	25.25	25.325	5454385.0
2011-04-15 14:00:00	MSFT	Stock	25.33	25.39	25.31	25.365	4585017.0
2011-04-15 14:30:00	MSFT	Stock	25.36	25.41	25.35	25.38	1872997.0
2011-04-15 15:00:00	MSFT	Stock	25.375	25.39	25.29	25.32	1972494.0
2011-04-15 15:30:00	MSFT	Stock	25.32	25.37	25.27	25.37	5697639.0
2011-04-15 16:00:00	MSFT	Stock	25.37	25.4	25.322	25.39	13383767.0

> showing 50 of 77,157 rows — these rows as CSV

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