PREVIEW / stock_5min / 2007-03-20

all stock 5-min files

  file:    by_date/stock_5min/2007/2007-03-20.parquet
  size:    3.5 MB
  rows:    252,529
  symbols: 2,548

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-03-20 07:25:00	AAPL	Stock	3.2607	3.2607	3.2607	3.2607	14000.0
2007-03-20 07:40:00	AAPL	Stock	3.255	3.2554	3.255	3.2554	44800.0
2007-03-20 07:45:00	AAPL	Stock	3.2629	3.2679	3.2629	3.2679	207200.0
2007-03-20 07:50:00	AAPL	Stock	3.2639	3.2654	3.2639	3.2643	90440.0
2007-03-20 07:55:00	AAPL	Stock	3.2639	3.2643	3.2639	3.2643	113960.0
2007-03-20 08:00:00	AAPL	Stock	3.2643	3.2643	3.2629	3.2639	436800.0
2007-03-20 08:05:00	AAPL	Stock	3.2632	3.2632	3.2546	3.2554	282800.0
2007-03-20 08:10:00	AAPL	Stock	3.2554	3.2568	3.2554	3.2568	165200.0
2007-03-20 08:15:00	AAPL	Stock	3.2589	3.2589	3.2564	3.2589	536928.0
2007-03-20 08:20:00	AAPL	Stock	3.2579	3.2589	3.2554	3.2571	257600.0
2007-03-20 08:25:00	AAPL	Stock	3.2571	3.2571	3.2564	3.2564	130032.0
2007-03-20 08:30:00	AAPL	Stock	3.2582	3.2611	3.2571	3.2611	387520.0
2007-03-20 08:35:00	AAPL	Stock	3.2607	3.2636	3.2607	3.2611	244664.0
2007-03-20 08:40:00	AAPL	Stock	3.2629	3.2636	3.2607	3.2607	169120.0
2007-03-20 08:45:00	AAPL	Stock	3.2589	3.2607	3.2586	3.2596	128240.0
2007-03-20 08:50:00	AAPL	Stock	3.26	3.2625	3.26	3.2625	113260.0
2007-03-20 08:55:00	AAPL	Stock	3.2607	3.2607	3.2607	3.2607	2800.0
2007-03-20 09:00:00	AAPL	Stock	3.2607	3.2625	3.2596	3.2625	144200.0
2007-03-20 09:05:00	AAPL	Stock	3.2611	3.2632	3.2607	3.2607	69300.0
2007-03-20 09:10:00	AAPL	Stock	3.2618	3.2625	3.2618	3.2618	199920.0
2007-03-20 09:15:00	AAPL	Stock	3.2618	3.2621	3.2618	3.2618	187600.0
2007-03-20 09:20:00	AAPL	Stock	3.2621	3.2632	3.2618	3.2625	522200.0
2007-03-20 09:25:00	AAPL	Stock	3.2621	3.2632	3.2611	3.2629	342860.0
2007-03-20 09:30:00	AAPL	Stock	3.2618	3.2714	3.2579	3.2664	19563992.0
2007-03-20 09:35:00	AAPL	Stock	3.2661	3.2736	3.2629	3.2675	16877644.0
2007-03-20 09:40:00	AAPL	Stock	3.2679	3.2732	3.2604	3.2696	12820444.0
2007-03-20 09:45:00	AAPL	Stock	3.2693	3.2732	3.2632	3.265	14662592.0
2007-03-20 09:50:00	AAPL	Stock	3.265	3.2679	3.2618	3.2624	9599940.0
2007-03-20 09:55:00	AAPL	Stock	3.2625	3.27	3.2521	3.2579	18163796.0
2007-03-20 10:00:00	AAPL	Stock	3.2571	3.2729	3.2543	3.26	8226400.0
2007-03-20 10:05:00	AAPL	Stock	3.26	3.2664	3.2571	3.2611	6848436.0
2007-03-20 10:10:00	AAPL	Stock	3.2611	3.2679	3.2596	3.2607	9102100.0
2007-03-20 10:15:00	AAPL	Stock	3.261	3.2632	3.2557	3.2571	6681556.0
2007-03-20 10:20:00	AAPL	Stock	3.2571	3.2629	3.2557	3.2607	7624540.0
2007-03-20 10:25:00	AAPL	Stock	3.2611	3.2639	3.2593	3.2639	5317368.0
2007-03-20 10:30:00	AAPL	Stock	3.2636	3.2639	3.2604	3.2604	4541768.0
2007-03-20 10:35:00	AAPL	Stock	3.2604	3.2643	3.2604	3.2611	6606572.0
2007-03-20 10:40:00	AAPL	Stock	3.2614	3.2639	3.2589	3.2618	6946996.0
2007-03-20 10:45:00	AAPL	Stock	3.2618	3.2643	3.2596	3.2607	3786972.0
2007-03-20 10:50:00	AAPL	Stock	3.2607	3.2679	3.2607	3.2639	7047068.0
2007-03-20 10:55:00	AAPL	Stock	3.2636	3.2654	3.2607	3.2621	6094536.0
2007-03-20 11:00:00	AAPL	Stock	3.2618	3.2636	3.2586	3.2611	5927124.0
2007-03-20 11:05:00	AAPL	Stock	3.2611	3.2675	3.2604	3.2661	6059144.0
2007-03-20 11:10:00	AAPL	Stock	3.2661	3.2668	3.2629	3.2629	4058152.0
2007-03-20 11:15:00	AAPL	Stock	3.2629	3.2661	3.2616	3.2646	3873184.0
2007-03-20 11:20:00	AAPL	Stock	3.265	3.2668	3.2607	3.2625	3763592.0
2007-03-20 11:25:00	AAPL	Stock	3.2629	3.2654	3.2607	3.2654	3050628.0
2007-03-20 11:30:00	AAPL	Stock	3.2654	3.2675	3.2639	3.2639	2804788.0
2007-03-20 11:35:00	AAPL	Stock	3.2639	3.2657	3.2621	3.2654	3712184.0
2007-03-20 11:40:00	AAPL	Stock	3.265	3.2732	3.265	3.2718	10444560.0

> showing 50 of 252,529 rows — these rows as CSV

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