PREVIEW / etf_30min / 2009-11-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-17.parquet
  size:    238 KB
  rows:    7,868

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-11-17 04:00:00	SPY	ETF	110.93	110.93	110.93	110.93	100.0
2009-11-17 04:30:00	SPY	ETF	111.01	111.02	111.01	111.02	600.0
2009-11-17 05:00:00	SPY	ETF	110.96	110.97	110.96	110.97	1500.0
2009-11-17 05:30:00	SPY	ETF	111.0	111.01	111.0	111.01	300.0
2009-11-17 06:00:00	SPY	ETF	110.95	110.98	110.84	110.86	38600.0
2009-11-17 06:30:00	SPY	ETF	111.01	111.07	110.99	111.07	13100.0
2009-11-17 07:00:00	SPY	ETF	111.04	111.04	110.65	110.76	131862.0
2009-11-17 07:30:00	SPY	ETF	110.76	110.86	110.68	110.86	115751.0
2009-11-17 08:00:00	SPY	ETF	110.58	111.05	110.58	110.86	675439.0
2009-11-17 08:30:00	SPY	ETF	110.86	111.04	110.74	110.95	1757998.0
2009-11-17 09:00:00	SPY	ETF	110.95	111.22	110.81	110.93	1040011.0
2009-11-17 09:30:00	SPY	ETF	110.92	111.23	110.74	110.991	21768657.0
2009-11-17 10:00:00	SPY	ETF	111.0	111.15	110.79	111.07	15242128.0
2009-11-17 10:30:00	SPY	ETF	111.07	111.08	110.52	110.78	13192257.0
2009-11-17 11:00:00	SPY	ETF	110.779	110.88	110.5	110.71	8856462.0
2009-11-17 11:30:00	SPY	ETF	110.71	110.85	110.64	110.7999	6665241.0
2009-11-17 12:00:00	SPY	ETF	110.79	111.12	110.71	111.02	6249526.0
2009-11-17 12:30:00	SPY	ETF	111.02	111.17	110.96	111.0	4783242.0
2009-11-17 13:00:00	SPY	ETF	111.0	111.13	110.82	111.0	7031080.0
2009-11-17 13:30:00	SPY	ETF	110.9999	111.29	110.99	111.16	6070047.0
2009-11-17 14:00:00	SPY	ETF	111.15	111.17	111.0	111.03	5471243.0
2009-11-17 14:30:00	SPY	ETF	111.04	111.14	110.89	111.04	9553026.0
2009-11-17 15:00:00	SPY	ETF	111.03	111.27	111.01	111.19	7983782.0
2009-11-17 15:30:00	SPY	ETF	111.185	111.39	111.11	111.33	15416210.0
2009-11-17 16:00:00	SPY	ETF	111.34	111.34	110.5451	111.24	8280169.0
2009-11-17 16:30:00	SPY	ETF	111.24	111.33	111.19	111.23	957294.0
2009-11-17 17:00:00	SPY	ETF	111.23	111.26	111.22	111.23	3115707.0
2009-11-17 17:30:00	SPY	ETF	111.23	111.26	111.2	111.24	47038.0
2009-11-17 18:00:00	SPY	ETF	111.24	111.28	111.21	111.27	18489.0
2009-11-17 18:30:00	SPY	ETF	111.27	111.34	111.27	111.34	84336.0
2009-11-17 19:00:00	SPY	ETF	111.33	111.52	111.33	111.5	74755.0
2009-11-17 19:30:00	SPY	ETF	111.48	111.55	111.47	111.51	46845.0
2009-11-17 04:30:00	QQQ	ETF	44.4	44.4	44.4	44.4	300.0
2009-11-17 05:00:00	QQQ	ETF	44.38	44.38	44.38	44.38	1000.0
2009-11-17 06:00:00	QQQ	ETF	44.35	44.35	44.31	44.31	10000.0
2009-11-17 06:30:00	QQQ	ETF	44.38	44.4	44.38	44.4	200.0
2009-11-17 07:00:00	QQQ	ETF	44.37	44.37	44.23	44.24	282047.0
2009-11-17 07:30:00	QQQ	ETF	44.24	44.31	44.24	44.3	135050.0
2009-11-17 08:00:00	QQQ	ETF	44.18	44.36	44.18	44.29	568137.0
2009-11-17 08:30:00	QQQ	ETF	44.28	44.34	44.26	44.31	1293344.0
2009-11-17 09:00:00	QQQ	ETF	44.32	44.35	44.29	44.34	643702.0
2009-11-17 09:30:00	QQQ	ETF	44.34	44.55	44.32	44.46	14757505.0
2009-11-17 10:00:00	QQQ	ETF	44.46	44.5088	44.36	44.44	9423029.0
2009-11-17 10:30:00	QQQ	ETF	44.43	44.44	44.25	44.33	5562631.0
2009-11-17 11:00:00	QQQ	ETF	44.32	44.38	44.25	44.32	5016362.0
2009-11-17 11:30:00	QQQ	ETF	44.32	44.39	44.29	44.3818	3250007.0
2009-11-17 12:00:00	QQQ	ETF	44.39	44.5	44.345	44.46	3538989.0
2009-11-17 12:30:00	QQQ	ETF	44.46	44.51	44.42	44.43	2996278.0
2009-11-17 13:00:00	QQQ	ETF	44.43	44.49	44.38	44.45	3560635.0
2009-11-17 13:30:00	QQQ	ETF	44.45	44.55	44.44	44.5078	3596496.0

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

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