PREVIEW / etf_30min / 2008-05-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-07.parquet
  size:    169 KB
  rows:    5,731

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
2008-05-07 04:00:00	SPY	ETF	141.6	141.62	141.6	141.6	2100.0
2008-05-07 04:30:00	SPY	ETF	141.5	141.5	141.5	141.5	1000.0
2008-05-07 05:30:00	SPY	ETF	141.81	141.81	141.81	141.81	1000.0
2008-05-07 06:00:00	SPY	ETF	141.87	141.87	141.87	141.87	200.0
2008-05-07 06:30:00	SPY	ETF	141.91	141.91	141.83	141.84	127600.0
2008-05-07 07:00:00	SPY	ETF	141.93	141.95	141.72	141.72	213800.0
2008-05-07 07:30:00	SPY	ETF	141.7	141.72	141.6	141.7	411071.0
2008-05-07 08:00:00	SPY	ETF	141.7	141.81	141.31	141.81	743024.0
2008-05-07 08:30:00	SPY	ETF	141.81	142.13	141.78	142.0	2473295.0
2008-05-07 09:00:00	SPY	ETF	141.99	142.02	141.85	141.88	529680.0
2008-05-07 09:30:00	SPY	ETF	141.89	141.95	141.57	141.68	12658423.0
2008-05-07 10:00:00	SPY	ETF	141.67	141.81	141.38	141.74	11783084.0
2008-05-07 10:30:00	SPY	ETF	141.73	142.04	141.44	141.47	11908522.0
2008-05-07 11:00:00	SPY	ETF	141.48	141.58	141.29	141.34	10339400.0
2008-05-07 11:30:00	SPY	ETF	141.34	141.37	141.02	141.14	8211793.0
2008-05-07 12:00:00	SPY	ETF	141.14	141.32	141.0	141.1	5794271.0
2008-05-07 12:30:00	SPY	ETF	141.11	141.3	141.08	141.24	5996953.0
2008-05-07 13:00:00	SPY	ETF	141.24	141.26	140.72	140.88	11210405.0
2008-05-07 13:30:00	SPY	ETF	140.88	140.94	140.63	140.759	5933440.0
2008-05-07 14:00:00	SPY	ETF	140.76	140.85	140.1	140.16	13483974.0
2008-05-07 14:30:00	SPY	ETF	140.15	140.16	139.61	139.9	24478307.0
2008-05-07 15:00:00	SPY	ETF	139.88	141.8858	139.18	139.389	20399219.0
2008-05-07 15:30:00	SPY	ETF	139.3804	139.9	139.13	139.28	34620293.0
2008-05-07 16:00:00	SPY	ETF	139.3	141.8857	139.26	139.47	12109801.0
2008-05-07 16:30:00	SPY	ETF	139.5	141.1462	139.46	139.55	3323563.0
2008-05-07 17:00:00	SPY	ETF	139.53	139.59	139.53	139.55	17360.0
2008-05-07 17:30:00	SPY	ETF	139.52	139.57	139.48	139.57	20100.0
2008-05-07 18:00:00	SPY	ETF	139.56	139.63	139.51	139.59	16267.0
2008-05-07 18:30:00	SPY	ETF	139.59	139.66	139.46	139.55	39242.0
2008-05-07 19:00:00	SPY	ETF	139.51	139.55	139.51	139.55	2700.0
2008-05-07 19:30:00	SPY	ETF	139.57	139.67	139.57	139.65	5465.0
2008-05-07 05:30:00	QQQ	ETF	48.98	48.98	48.98	48.98	1000.0
2008-05-07 06:00:00	QQQ	ETF	48.95	49.05	48.95	49.05	101100.0
2008-05-07 06:30:00	QQQ	ETF	48.95	48.95	48.93	48.93	50000.0
2008-05-07 07:00:00	QQQ	ETF	48.95	48.95	48.86	48.89	100360.0
2008-05-07 07:30:00	QQQ	ETF	48.87	48.87	48.82	48.84	568039.0
2008-05-07 08:00:00	QQQ	ETF	48.84	48.85	48.82	48.85	645537.0
2008-05-07 08:30:00	QQQ	ETF	48.85	49.06	48.85	48.98	1534038.0
2008-05-07 09:00:00	QQQ	ETF	48.98	48.98	48.9	48.93	303289.0
2008-05-07 09:30:00	QQQ	ETF	48.93	49.04	48.78	48.93	12122931.0
2008-05-07 10:00:00	QQQ	ETF	48.93	49.05	48.83	49.02	8793449.0
2008-05-07 10:30:00	QQQ	ETF	49.02	49.23	48.97	48.9801	9993686.0
2008-05-07 11:00:00	QQQ	ETF	48.98	49.07	48.86	48.87	6000661.0
2008-05-07 11:30:00	QQQ	ETF	48.86	48.88	48.71	48.7695	6227348.0
2008-05-07 12:00:00	QQQ	ETF	48.77	48.85	48.64	48.66	7641135.0
2008-05-07 12:30:00	QQQ	ETF	48.66	48.78	48.66	48.76	4046889.0
2008-05-07 13:00:00	QQQ	ETF	48.77	48.775	48.49	48.53	8270685.0
2008-05-07 13:30:00	QQQ	ETF	48.54	48.55	48.3	48.38	6589621.0
2008-05-07 14:00:00	QQQ	ETF	48.39	48.46	48.2	48.25	10005787.0
2008-05-07 14:30:00	QQQ	ETF	48.2475	48.26	48.01	48.13	18168524.0

> showing 50 of 5,731 rows — these rows as CSV

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