PREVIEW / stock_30min / 2010-11-15

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-15.parquet
  size:    1.4 MB
  rows:    74,654
  symbols: 3,507

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-11-15 04:00:00	AAPL	Stock	11.0154	11.0154	11.0154	11.0154	2800.0
2010-11-15 06:00:00	AAPL	Stock	11.0536	11.0536	11.0536	11.0536	3640.0
2010-11-15 06:30:00	AAPL	Stock	11.0536	11.0625	11.0536	11.0625	39200.0
2010-11-15 07:00:00	AAPL	Stock	11.0536	11.0693	11.0446	11.0564	238168.0
2010-11-15 07:30:00	AAPL	Stock	11.0579	11.0764	11.0579	11.0714	176876.0
2010-11-15 08:00:00	AAPL	Stock	11.0625	11.0786	11.0489	11.0707	1787548.0
2010-11-15 08:30:00	AAPL	Stock	11.0668	11.0746	11.0554	11.0714	1634864.0
2010-11-15 09:00:00	AAPL	Stock	11.0718	11.0761	11.0182	11.0182	1462916.0
2010-11-15 09:30:00	AAPL	Stock	11.0182	11.0907	10.9964	11.0068	69528424.0
2010-11-15 10:00:00	AAPL	Stock	11.0054	11.0471	10.9382	11.0257	60769968.0
2010-11-15 10:30:00	AAPL	Stock	11.0268	11.0554	11.0121	11.0425	32326588.0
2010-11-15 11:00:00	AAPL	Stock	11.0419	11.0571	10.9754	10.9829	30906092.0
2010-11-15 11:30:00	AAPL	Stock	10.9829	11.0386	10.981	11.0207	20916644.0
2010-11-15 12:00:00	AAPL	Stock	11.0217	11.0439	11.0029	11.0125	14377916.0
2010-11-15 12:30:00	AAPL	Stock	11.0125	11.0525	10.9957	11.0464	15097572.0
2010-11-15 13:00:00	AAPL	Stock	11.0464	11.0489	11.0079	11.0357	15860656.0
2010-11-15 13:30:00	AAPL	Stock	11.0361	11.0482	11.0196	11.0196	10561824.0
2010-11-15 14:00:00	AAPL	Stock	11.021	11.0357	10.9821	10.9986	18825016.0
2010-11-15 14:30:00	AAPL	Stock	10.9986	11.0204	10.9879	11.0117	13469792.0
2010-11-15 15:00:00	AAPL	Stock	11.0089	11.0179	10.9625	10.9804	31002552.0
2010-11-15 15:30:00	AAPL	Stock	10.9804	10.9879	10.9557	10.9789	40340944.0
2010-11-15 16:00:00	AAPL	Stock	10.9789	11.0116	10.95	10.9767	11735416.0
2010-11-15 16:30:00	AAPL	Stock	10.9679	11.0628	10.9571	10.9711	3277372.0
2010-11-15 17:00:00	AAPL	Stock	10.9711	10.9982	10.9675	10.9954	336784.0
2010-11-15 17:30:00	AAPL	Stock	10.9964	11.0036	10.9786	10.9868	635628.0
2010-11-15 18:00:00	AAPL	Stock	10.9882	11.0143	10.9657	11.0032	422828.0
2010-11-15 18:30:00	AAPL	Stock	10.9964	10.9964	10.9857	10.9921	59500.0
2010-11-15 19:00:00	AAPL	Stock	10.9904	10.9914	10.9696	10.9782	347480.0
2010-11-15 19:30:00	AAPL	Stock	10.9686	10.9814	10.9661	10.9782	154000.0
2010-11-15 07:00:00	MSFT	Stock	26.29	26.3	26.29	26.3	200.0
2010-11-15 07:30:00	MSFT	Stock	26.29	26.29	26.29	26.29	800.0
2010-11-15 08:00:00	MSFT	Stock	26.28	26.31	26.28	26.31	4280.0
2010-11-15 08:30:00	MSFT	Stock	26.31	26.33	26.3	26.3	17880.0
2010-11-15 09:00:00	MSFT	Stock	26.3	26.42	26.3	26.33	59650.0
2010-11-15 09:30:00	MSFT	Stock	26.33	26.5	26.29	26.29	7233574.0
2010-11-15 10:00:00	MSFT	Stock	26.3	26.36	26.2	26.345	4261155.0
2010-11-15 10:30:00	MSFT	Stock	26.35	26.35	26.23	26.258	3186545.0
2010-11-15 11:00:00	MSFT	Stock	26.255	26.3	26.18	26.21	4134987.0
2010-11-15 11:30:00	MSFT	Stock	26.21	26.37	26.17	26.321	2605118.0
2010-11-15 12:00:00	MSFT	Stock	26.32	26.36	26.2	26.26	2106615.0
2010-11-15 12:30:00	MSFT	Stock	26.25	26.28	26.245	26.26	1187800.0
2010-11-15 13:00:00	MSFT	Stock	26.262	26.285	26.24	26.262	2032589.0
2010-11-15 13:30:00	MSFT	Stock	26.26	26.29	26.24	26.25	2182929.0
2010-11-15 14:00:00	MSFT	Stock	26.25	26.28	26.22	26.27	2691191.0
2010-11-15 14:30:00	MSFT	Stock	26.26	26.38	26.255	26.345	2220828.0
2010-11-15 15:00:00	MSFT	Stock	26.35	26.35	26.25	26.28	5593000.0
2010-11-15 15:30:00	MSFT	Stock	26.28	26.31	26.2	26.24	6353986.0
2010-11-15 16:00:00	MSFT	Stock	26.23	26.29	26.18	26.235	2957851.0
2010-11-15 16:30:00	MSFT	Stock	26.2	26.29	26.2	26.29	730605.0
2010-11-15 17:00:00	MSFT	Stock	26.22	26.22	26.21	26.21	4393.0

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

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