PREVIEW / etf_30min / 2009-01-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-13.parquet
  size:    197 KB
  rows:    6,485

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-01-13 04:00:00	SPY	ETF	86.55	86.64	86.49	86.49	4800.0
2009-01-13 04:30:00	SPY	ETF	86.68	86.72	86.68	86.72	1700.0
2009-01-13 05:00:00	SPY	ETF	86.5	86.66	86.5	86.61	5700.0
2009-01-13 05:30:00	SPY	ETF	86.54	86.54	86.08	86.25	15180.0
2009-01-13 06:00:00	SPY	ETF	86.24	86.41	86.15	86.41	9810.0
2009-01-13 06:30:00	SPY	ETF	86.37	86.5	86.33	86.34	15046.0
2009-01-13 07:00:00	SPY	ETF	86.39	86.78	86.39	86.76	227251.0
2009-01-13 07:30:00	SPY	ETF	86.75	86.85	86.6	86.65	269404.0
2009-01-13 08:00:00	SPY	ETF	86.65	86.69	86.38	86.4503	912509.0
2009-01-13 08:30:00	SPY	ETF	86.63	87.059	86.63	86.91	1585021.0
2009-01-13 09:00:00	SPY	ETF	86.9	87.01	86.7	86.74	1090371.0
2009-01-13 09:30:00	SPY	ETF	86.73	87.58	86.51	87.36	30905886.0
2009-01-13 10:00:00	SPY	ETF	87.36	87.88	87.05	87.17	26903452.0
2009-01-13 10:30:00	SPY	ETF	87.16	87.56	86.85	87.41	23172804.0
2009-01-13 11:00:00	SPY	ETF	87.41	87.63	86.97	87.41	23418173.0
2009-01-13 11:30:00	SPY	ETF	87.41	87.77	87.25	87.6175	23481225.0
2009-01-13 12:00:00	SPY	ETF	87.62	87.6992	87.21	87.3	13570950.0
2009-01-13 12:30:00	SPY	ETF	87.3	87.55	87.09	87.09	13140179.0
2009-01-13 13:00:00	SPY	ETF	87.0992	87.21	86.73	86.86	13569905.0
2009-01-13 13:30:00	SPY	ETF	86.85	86.95	86.29	86.37	16985094.0
2009-01-13 14:00:00	SPY	ETF	86.37	86.78	86.2	86.36	16728329.0
2009-01-13 14:30:00	SPY	ETF	86.36	87.44	86.35	86.98	37708981.0
2009-01-13 15:00:00	SPY	ETF	86.98	87.11	86.37	86.98	35780573.0
2009-01-13 15:30:00	SPY	ETF	86.98	87.48	86.49	87.1	53805068.0
2009-01-13 16:00:00	SPY	ETF	87.08	87.29	87.01	87.27	3458580.0
2009-01-13 16:30:00	SPY	ETF	87.26	87.26	87.05	87.15	12694521.0
2009-01-13 17:00:00	SPY	ETF	87.13	87.27	87.0596	87.27	2878788.0
2009-01-13 17:30:00	SPY	ETF	87.26	87.3	87.0596	87.28	524833.0
2009-01-13 18:00:00	SPY	ETF	87.29	87.33	87.19	87.31	183194.0
2009-01-13 18:30:00	SPY	ETF	87.3	87.36	87.3	87.34	44554.0
2009-01-13 19:00:00	SPY	ETF	87.33	87.62	87.33	87.6	96334.0
2009-01-13 19:30:00	SPY	ETF	87.6	87.69	87.55	87.6	82884.0
2009-01-13 04:00:00	QQQ	ETF	29.46	29.46	29.46	29.46	575.0
2009-01-13 04:30:00	QQQ	ETF	29.5	29.5	29.5	29.5	100.0
2009-01-13 05:00:00	QQQ	ETF	29.43	29.43	29.43	29.43	100.0
2009-01-13 05:30:00	QQQ	ETF	29.43	29.43	29.38	29.38	200.0
2009-01-13 06:00:00	QQQ	ETF	29.35	29.35	29.35	29.35	200.0
2009-01-13 06:30:00	QQQ	ETF	29.39	29.39	29.33	29.35	22182.0
2009-01-13 07:00:00	QQQ	ETF	29.4	29.51	29.4	29.48	134967.0
2009-01-13 07:30:00	QQQ	ETF	29.45	29.51	29.45	29.46	36727.0
2009-01-13 08:00:00	QQQ	ETF	29.47	29.51	29.4	29.49	737934.0
2009-01-13 08:30:00	QQQ	ETF	29.51	29.69	29.4	29.66	1364059.0
2009-01-13 09:00:00	QQQ	ETF	29.66	29.66	29.5	29.51	584480.0
2009-01-13 09:30:00	QQQ	ETF	29.51	29.98	29.45	29.89	27308316.0
2009-01-13 10:00:00	QQQ	ETF	29.89	29.97	29.7	29.7299	13403744.0
2009-01-13 10:30:00	QQQ	ETF	29.72	29.84	29.6	29.79	10650962.0
2009-01-13 11:00:00	QQQ	ETF	29.78	29.84	29.59	29.72	7324435.0
2009-01-13 11:30:00	QQQ	ETF	29.72	29.82	29.64	29.76	9278735.0
2009-01-13 12:00:00	QQQ	ETF	29.76	29.78	29.65	29.68	4858116.0
2009-01-13 12:30:00	QQQ	ETF	29.678	29.72	29.51	29.51	6873323.0

> showing 50 of 6,485 rows — these rows as CSV

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