PREVIEW / etf_30min / 2009-08-07

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-07.parquet
  size:    236 KB
  rows:    7,681

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
2009-08-07 04:00:00	SPY	ETF	99.55	99.57	99.55	99.55	1850.0
2009-08-07 04:30:00	SPY	ETF	99.5	99.67	99.5	99.54	900.0
2009-08-07 05:00:00	SPY	ETF	99.62	99.75	99.6	99.75	5700.0
2009-08-07 05:30:00	SPY	ETF	99.6	99.6	99.6	99.6	100.0
2009-08-07 06:00:00	SPY	ETF	99.5	99.55	99.45	99.5	10900.0
2009-08-07 06:30:00	SPY	ETF	99.51	99.6	99.5	99.55	9400.0
2009-08-07 07:00:00	SPY	ETF	99.57	99.75	99.56	99.62	335549.0
2009-08-07 07:30:00	SPY	ETF	99.62	99.87	99.61	99.8	343925.0
2009-08-07 08:00:00	SPY	ETF	99.79	99.95	99.72	99.85	1641578.0
2009-08-07 08:30:00	SPY	ETF	99.97	100.93	99.88	100.74	11499327.0
2009-08-07 09:00:00	SPY	ETF	100.73	101.19	100.73	100.92	4426681.0
2009-08-07 09:30:00	SPY	ETF	100.94	101.18	100.63	100.63	27718003.0
2009-08-07 10:00:00	SPY	ETF	100.63	100.92	100.39	100.82	25256346.0
2009-08-07 10:30:00	SPY	ETF	100.81	101.63	100.8	101.53	27331056.0
2009-08-07 11:00:00	SPY	ETF	101.53	101.75	101.46	101.55	12372462.0
2009-08-07 11:30:00	SPY	ETF	101.54	101.73	101.27	101.51	12258541.0
2009-08-07 12:00:00	SPY	ETF	101.51	101.6	101.4	101.46	8605683.0
2009-08-07 12:30:00	SPY	ETF	101.46	101.74	101.35	101.6375	6801221.0
2009-08-07 13:00:00	SPY	ETF	101.64	102.0	101.62	101.96	9361446.0
2009-08-07 13:30:00	SPY	ETF	101.97	102.03	101.0	101.8399	8004628.0
2009-08-07 14:00:00	SPY	ETF	101.84	101.92	101.66	101.73	7612299.0
2009-08-07 14:30:00	SPY	ETF	101.73	101.78	101.62	101.64	5326971.0
2009-08-07 15:00:00	SPY	ETF	101.64	101.65	101.2	101.5001	18417252.0
2009-08-07 15:30:00	SPY	ETF	101.5	101.56	101.19	101.19	20648330.0
2009-08-07 16:00:00	SPY	ETF	101.18	101.84	100.5048	101.12	10088188.0
2009-08-07 16:30:00	SPY	ETF	101.16	101.17	100.89	100.9	336089.0
2009-08-07 17:00:00	SPY	ETF	100.9	100.95	100.82	100.84	160975.0
2009-08-07 17:30:00	SPY	ETF	100.84	100.94	100.82	100.94	94818.0
2009-08-07 18:00:00	SPY	ETF	100.93	101.04	100.92	100.97	15719.0
2009-08-07 18:30:00	SPY	ETF	100.98	101.0	100.97	100.97	10114.0
2009-08-07 19:00:00	SPY	ETF	100.97	101.08	100.93	101.0	17696.0
2009-08-07 19:30:00	SPY	ETF	100.98	101.09	100.95	101.09	7377.0
2009-08-07 04:00:00	QQQ	ETF	39.32	39.32	39.32	39.32	200.0
2009-08-07 04:30:00	QQQ	ETF	39.35	39.35	39.33	39.33	695.0
2009-08-07 06:00:00	QQQ	ETF	39.31	39.31	39.31	39.31	1000.0
2009-08-07 07:00:00	QQQ	ETF	39.37	39.37	39.32	39.35	89925.0
2009-08-07 07:30:00	QQQ	ETF	39.36	39.46	39.36	39.41	175769.0
2009-08-07 08:00:00	QQQ	ETF	39.41	39.6	39.38	39.6	852888.0
2009-08-07 08:30:00	QQQ	ETF	39.59	39.93	39.55	39.85	2245455.0
2009-08-07 09:00:00	QQQ	ETF	39.86	40.03	39.86	39.92	1047388.0
2009-08-07 09:30:00	QQQ	ETF	39.92	40.03	39.72	39.72	19593396.0
2009-08-07 10:00:00	QQQ	ETF	39.72	39.74	39.59	39.71	10758318.0
2009-08-07 10:30:00	QQQ	ETF	39.71	40.0	39.61	39.95	9919836.0
2009-08-07 11:00:00	QQQ	ETF	39.96	40.05	39.93	39.97	6322052.0
2009-08-07 11:30:00	QQQ	ETF	39.96	40.07	39.89	39.97	5972712.0
2009-08-07 12:00:00	QQQ	ETF	39.97	40.0	39.8844	39.93	3978507.0
2009-08-07 12:30:00	QQQ	ETF	39.94	40.02	39.92	39.98	2599356.0
2009-08-07 13:00:00	QQQ	ETF	39.98	40.06	39.96	40.05	4011016.0
2009-08-07 13:30:00	QQQ	ETF	40.06	40.07	39.99	40.03	4502453.0
2009-08-07 14:00:00	QQQ	ETF	40.02	40.0599	39.97	39.9896	2486234.0

> showing 50 of 7,681 rows — these rows as CSV

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