PREVIEW / etf_30min / 2009-11-04

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-04.parquet
  size:    236 KB
  rows:    7,850

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-04 04:00:00	SPY	ETF	105.22	105.27	105.21	105.25	1410.0
2009-11-04 04:30:00	SPY	ETF	105.29	105.33	105.29	105.33	400.0
2009-11-04 05:00:00	SPY	ETF	105.32	105.35	105.31	105.32	1700.0
2009-11-04 05:30:00	SPY	ETF	105.37	105.37	105.31	105.33	800.0
2009-11-04 06:00:00	SPY	ETF	105.27	105.34	105.27	105.34	4700.0
2009-11-04 06:30:00	SPY	ETF	105.28	105.36	105.28	105.36	1100.0
2009-11-04 07:00:00	SPY	ETF	105.34	105.38	105.14	105.2	145538.0
2009-11-04 07:30:00	SPY	ETF	105.22	105.23	105.12	105.2	191990.0
2009-11-04 08:00:00	SPY	ETF	105.19	105.38	104.53	105.36	1619701.0
2009-11-04 08:30:00	SPY	ETF	105.37	105.62	104.65	105.47	1350314.0
2009-11-04 09:00:00	SPY	ETF	105.47	105.64	105.45	105.5	2430631.0
2009-11-04 09:30:00	SPY	ETF	105.51	105.72	105.25	105.57	21133832.0
2009-11-04 10:00:00	SPY	ETF	105.58	106.19	105.34	106.03	29292024.0
2009-11-04 10:30:00	SPY	ETF	106.04	106.26	105.95	106.24	18640108.0
2009-11-04 11:00:00	SPY	ETF	106.25	106.25	105.96	105.97	8851992.0
2009-11-04 11:30:00	SPY	ETF	105.97	106.01	105.8	105.86	8101826.0
2009-11-04 12:00:00	SPY	ETF	105.87	105.94	105.65	105.81	8995049.0
2009-11-04 12:30:00	SPY	ETF	105.81	105.9	105.71	105.77	5025135.0
2009-11-04 13:00:00	SPY	ETF	105.77	105.8	105.62	105.69	5050591.0
2009-11-04 13:30:00	SPY	ETF	105.68	105.73	105.58	105.69	5594035.0
2009-11-04 14:00:00	SPY	ETF	105.68	106.15	105.11	105.22	26441689.0
2009-11-04 14:30:00	SPY	ETF	105.22	106.33	105.11	106.09	29496004.0
2009-11-04 15:00:00	SPY	ETF	106.09	106.115	105.65	105.79	14554998.0
2009-11-04 15:30:00	SPY	ETF	105.78	105.83	104.65	104.84	38883357.0
2009-11-04 16:00:00	SPY	ETF	104.84	106.29	104.81	105.14	8710783.0
2009-11-04 16:30:00	SPY	ETF	105.14	105.25	104.831	105.15	8834817.0
2009-11-04 17:00:00	SPY	ETF	104.7236	105.24	104.7236	105.12	3655255.0
2009-11-04 17:30:00	SPY	ETF	105.15	105.19	105.11	105.14	29714.0
2009-11-04 18:00:00	SPY	ETF	105.16	105.2	105.15	105.17	34628.0
2009-11-04 18:30:00	SPY	ETF	105.15	105.18	104.97	104.98	152024.0
2009-11-04 19:00:00	SPY	ETF	104.98	105.04	104.92	105.02	127196.0
2009-11-04 19:30:00	SPY	ETF	105.03	105.06	104.88	104.91	243649.0
2009-11-04 04:00:00	QQQ	ETF	41.39	41.4	41.39	41.4	210.0
2009-11-04 04:30:00	QQQ	ETF	41.41	41.41	41.41	41.41	100.0
2009-11-04 05:00:00	QQQ	ETF	41.45	41.45	41.45	41.45	12500.0
2009-11-04 05:30:00	QQQ	ETF	41.41	41.41	41.41	41.41	200.0
2009-11-04 06:00:00	QQQ	ETF	41.44	41.44	41.44	41.44	100.0
2009-11-04 07:00:00	QQQ	ETF	41.43	41.43	41.36	41.39	22600.0
2009-11-04 07:30:00	QQQ	ETF	41.4	41.4	41.35	41.39	43713.0
2009-11-04 08:00:00	QQQ	ETF	41.37	41.46	41.37	41.46	387360.0
2009-11-04 08:30:00	QQQ	ETF	41.46	41.51	41.46	41.49	666201.0
2009-11-04 09:00:00	QQQ	ETF	41.49	41.54	41.48	41.52	476052.0
2009-11-04 09:30:00	QQQ	ETF	41.51	41.57	41.39	41.56	13048754.0
2009-11-04 10:00:00	QQQ	ETF	41.56	41.78	41.42	41.74	14571947.0
2009-11-04 10:30:00	QQQ	ETF	41.75	41.86	41.725	41.8501	5540622.0
2009-11-04 11:00:00	QQQ	ETF	41.86	41.87	41.76	41.79	3389856.0
2009-11-04 11:30:00	QQQ	ETF	41.78	41.78	41.69	41.7	3710445.0
2009-11-04 12:00:00	QQQ	ETF	41.7	41.75	41.64	41.68	2820918.0
2009-11-04 12:30:00	QQQ	ETF	41.68	41.72	41.65	41.68	2708274.0
2009-11-04 13:00:00	QQQ	ETF	41.672	41.7	41.6299	41.66	1673638.0

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

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