PREVIEW / stock_30min / 2007-11-07

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-07.parquet
  size:    1.2 MB
  rows:    69,706
  symbols: 3,210

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
2007-11-07 04:30:00	AAPL	Stock	6.8132	6.8132	6.795	6.795	21280.0
2007-11-07 05:30:00	AAPL	Stock	6.7957	6.7957	6.7857	6.7857	19600.0
2007-11-07 06:00:00	AAPL	Stock	6.7929	6.7929	6.7929	6.7929	2800.0
2007-11-07 06:30:00	AAPL	Stock	6.7929	6.7929	6.7857	6.7857	19600.0
2007-11-07 07:00:00	AAPL	Stock	6.7857	6.7857	6.7454	6.7661	315112.0
2007-11-07 07:30:00	AAPL	Stock	6.7661	6.8032	6.7661	6.7857	725060.0
2007-11-07 08:00:00	AAPL	Stock	6.7807	6.8014	6.7664	6.7964	4864048.0
2007-11-07 08:30:00	AAPL	Stock	6.7979	6.8104	6.7868	6.8054	2705416.0
2007-11-07 09:00:00	AAPL	Stock	6.8054	6.8125	6.7907	6.8054	2793560.0
2007-11-07 09:30:00	AAPL	Stock	6.8068	6.8404	6.775	6.8286	134047284.0
2007-11-07 10:00:00	AAPL	Stock	6.8286	6.8814	6.8071	6.8518	117427128.0
2007-11-07 10:30:00	AAPL	Stock	6.8518	6.8625	6.7961	6.8266	78273076.0
2007-11-07 11:00:00	AAPL	Stock	6.8268	6.8418	6.7857	6.8382	60797240.0
2007-11-07 11:30:00	AAPL	Stock	6.8382	6.8429	6.8104	6.8336	50745688.0
2007-11-07 12:00:00	AAPL	Stock	6.8339	6.8339	6.8036	6.8104	44475340.0
2007-11-07 12:30:00	AAPL	Stock	6.81	6.8225	6.7846	6.789	52123232.0
2007-11-07 13:00:00	AAPL	Stock	6.7893	6.8061	6.7521	6.7593	71577044.0
2007-11-07 13:30:00	AAPL	Stock	6.76	6.7893	6.7436	6.7593	65119068.0
2007-11-07 14:00:00	AAPL	Stock	6.7596	6.8	6.75	6.7914	64024996.0
2007-11-07 14:30:00	AAPL	Stock	6.7911	6.7954	6.7564	6.7715	44616712.0
2007-11-07 15:00:00	AAPL	Stock	6.7714	6.7954	6.7504	6.7525	51380840.0
2007-11-07 15:30:00	AAPL	Stock	6.7536	6.7607	6.6475	6.6611	125944700.0
2007-11-07 16:00:00	AAPL	Stock	6.6611	6.7943	6.6314	6.7725	14414904.0
2007-11-07 16:30:00	AAPL	Stock	6.6611	6.8225	6.5893	6.5964	3064572.0
2007-11-07 17:00:00	AAPL	Stock	6.5929	6.6611	6.5779	6.5854	1783600.0
2007-11-07 17:30:00	AAPL	Stock	6.5804	6.7918	6.5536	6.5821	1844640.0
2007-11-07 18:00:00	AAPL	Stock	6.585	6.6071	6.5789	6.6054	306348.0
2007-11-07 18:30:00	AAPL	Stock	6.6061	6.7942	6.5736	6.7942	523320.0
2007-11-07 19:00:00	AAPL	Stock	6.5804	6.5982	6.5804	6.5982	115920.0
2007-11-07 19:30:00	AAPL	Stock	6.5982	6.6143	6.5893	6.5964	246736.0
2007-11-07 05:00:00	MSFT	Stock	35.92	35.92	35.92	35.92	1000.0
2007-11-07 06:30:00	MSFT	Stock	35.9	35.91	35.9	35.91	1700.0
2007-11-07 07:00:00	MSFT	Stock	36.01	36.11	35.93	36.11	2700.0
2007-11-07 07:30:00	MSFT	Stock	36.03	36.09	36.03	36.03	5600.0
2007-11-07 08:00:00	MSFT	Stock	36.41	36.41	36.0	36.03	314019.0
2007-11-07 08:30:00	MSFT	Stock	36.03	36.14	36.01	36.07	24667.0
2007-11-07 09:00:00	MSFT	Stock	36.1	36.15	36.0	36.02	178151.0
2007-11-07 09:30:00	MSFT	Stock	36.03	36.16	36.0	36.07	6615891.0
2007-11-07 10:00:00	MSFT	Stock	36.07	36.1	35.96	36.01	5535087.0
2007-11-07 10:30:00	MSFT	Stock	36.0	36.001	35.89	35.92	5962556.0
2007-11-07 11:00:00	MSFT	Stock	35.92	35.97	35.85	35.87	3648144.0
2007-11-07 11:30:00	MSFT	Stock	35.88	36.15	35.84	36.111	5463777.0
2007-11-07 12:00:00	MSFT	Stock	36.11	36.12	36.05	36.07	5446719.0
2007-11-07 12:30:00	MSFT	Stock	36.071	36.12	35.94	36.03	2956821.0
2007-11-07 13:00:00	MSFT	Stock	36.03	36.03	35.81	35.86	5606532.0
2007-11-07 13:30:00	MSFT	Stock	35.86	35.95	35.85	35.86	3120442.0
2007-11-07 14:00:00	MSFT	Stock	35.86	35.95	35.82	35.94	4109286.0
2007-11-07 14:30:00	MSFT	Stock	35.95	35.95	35.8	35.87	4561915.0
2007-11-07 15:00:00	MSFT	Stock	35.87	35.94	35.71	35.74	5391083.0
2007-11-07 15:30:00	MSFT	Stock	35.74	35.9	35.45	35.52	12407839.0

> showing 50 of 69,706 rows — these rows as CSV

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