PREVIEW / etf_30min / 2009-06-01

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-01.parquet
  size:    230 KB
  rows:    7,764

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-06-01 04:00:00	SPY	ETF	93.72	93.72	93.64	93.7	4281.0
2009-06-01 04:30:00	SPY	ETF	93.76	93.8	93.74	93.76	14576.0
2009-06-01 05:00:00	SPY	ETF	93.83	93.85	93.68	93.7	31100.0
2009-06-01 05:30:00	SPY	ETF	93.79	93.83	93.77	93.83	21100.0
2009-06-01 06:00:00	SPY	ETF	93.83	94.1	93.81	93.85	37800.0
2009-06-01 06:30:00	SPY	ETF	93.9	93.93	93.64	93.66	58200.0
2009-06-01 07:00:00	SPY	ETF	93.64	93.71	93.44	93.6	448336.0
2009-06-01 07:30:00	SPY	ETF	93.58	93.63	93.33	93.44	601828.0
2009-06-01 08:00:00	SPY	ETF	93.44	93.85	93.44	93.56	2391837.0
2009-06-01 08:30:00	SPY	ETF	93.57	93.87	92.44	93.67	1957207.0
2009-06-01 09:00:00	SPY	ETF	93.67	93.75	93.1	93.65	2236974.0
2009-06-01 09:30:00	SPY	ETF	93.67	94.24	93.43	94.0	38839898.0
2009-06-01 10:00:00	SPY	ETF	94.02	94.65	94.015	94.44	34545528.0
2009-06-01 10:30:00	SPY	ETF	94.45	94.63	94.36	94.58	18520561.0
2009-06-01 11:00:00	SPY	ETF	94.57	94.76	94.51	94.64	9494638.0
2009-06-01 11:30:00	SPY	ETF	94.64	94.82	94.52	94.73	8623568.0
2009-06-01 12:00:00	SPY	ETF	94.73	94.84	94.63	94.81	8321433.0
2009-06-01 12:30:00	SPY	ETF	94.81	94.91	94.62	94.65	11775619.0
2009-06-01 13:00:00	SPY	ETF	94.66	94.7	94.56	94.69	7602775.0
2009-06-01 13:30:00	SPY	ETF	94.68	95.1	94.68	95.0301	10940065.0
2009-06-01 14:00:00	SPY	ETF	95.04	95.17	94.88	94.89	14467833.0
2009-06-01 14:30:00	SPY	ETF	94.89	94.97	94.65	94.79	15168636.0
2009-06-01 15:00:00	SPY	ETF	94.78	94.84	94.38	94.8301	25879761.0
2009-06-01 15:30:00	SPY	ETF	94.83	95.09	94.43	94.77	45787985.0
2009-06-01 16:00:00	SPY	ETF	94.74	94.8205	94.33	94.39	15565821.0
2009-06-01 16:30:00	SPY	ETF	94.38	94.38	94.25	94.32	1148734.0
2009-06-01 17:00:00	SPY	ETF	94.31	94.38	94.3	94.35	367949.0
2009-06-01 17:30:00	SPY	ETF	94.35	94.42	94.31	94.41	251871.0
2009-06-01 18:00:00	SPY	ETF	94.38	94.41	94.33	94.39	54001.0
2009-06-01 18:30:00	SPY	ETF	94.38	94.4	94.35	94.35	28208.0
2009-06-01 19:00:00	SPY	ETF	94.35	94.38	94.33	94.34	32154.0
2009-06-01 19:30:00	SPY	ETF	94.35	94.43	94.34	94.43	21420.0
2009-06-01 04:00:00	QQQ	ETF	35.7	35.72	35.69	35.69	892.0
2009-06-01 04:30:00	QQQ	ETF	35.74	35.74	35.74	35.74	300.0
2009-06-01 05:00:00	QQQ	ETF	35.75	35.79	35.75	35.79	2302.0
2009-06-01 05:30:00	QQQ	ETF	35.83	35.83	35.8	35.8	2263.0
2009-06-01 06:00:00	QQQ	ETF	35.8	35.91	35.8	35.91	3250.0
2009-06-01 06:30:00	QQQ	ETF	35.79	35.79	35.75	35.77	20800.0
2009-06-01 07:00:00	QQQ	ETF	35.73	35.73	35.64	35.67	45113.0
2009-06-01 07:30:00	QQQ	ETF	35.68	35.72	35.64	35.68	489770.0
2009-06-01 08:00:00	QQQ	ETF	35.66	35.81	35.66	35.71	457557.0
2009-06-01 08:30:00	QQQ	ETF	35.73	35.82	35.5	35.73	461006.0
2009-06-01 09:00:00	QQQ	ETF	35.73	35.79	35.38	35.74	2002527.0
2009-06-01 09:30:00	QQQ	ETF	35.73	36.05	35.61	35.98	16807942.0
2009-06-01 10:00:00	QQQ	ETF	35.98	36.25	35.97	36.2	11864442.0
2009-06-01 10:30:00	QQQ	ETF	36.2	36.26	36.14	36.23	6833314.0
2009-06-01 11:00:00	QQQ	ETF	36.23	36.29	36.22	36.26	6075895.0
2009-06-01 11:30:00	QQQ	ETF	36.259	36.36	36.24	36.32	7226422.0
2009-06-01 12:00:00	QQQ	ETF	36.32	36.39	36.29	36.3799	2786569.0
2009-06-01 12:30:00	QQQ	ETF	36.38	36.46	36.32	36.33	6431919.0

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

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