PREVIEW / etf_30min / 2009-02-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-06.parquet
  size:    204 KB
  rows:    6,707

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-02-06 04:00:00	SPY	ETF	84.25	84.25	84.25	84.25	1900.0
2009-02-06 04:30:00	SPY	ETF	84.52	84.52	84.5	84.5	800.0
2009-02-06 05:30:00	SPY	ETF	84.5	84.5	84.5	84.5	2500.0
2009-02-06 06:00:00	SPY	ETF	84.62	84.62	84.62	84.62	700.0
2009-02-06 06:30:00	SPY	ETF	84.49	84.78	84.49	84.73	37600.0
2009-02-06 07:00:00	SPY	ETF	84.7	84.8	84.6	84.62	213439.0
2009-02-06 07:30:00	SPY	ETF	84.63	84.68	84.42	84.62	379926.0
2009-02-06 08:00:00	SPY	ETF	84.62	84.77	84.42	84.58	1692394.0
2009-02-06 08:30:00	SPY	ETF	84.63	85.26	84.1	85.08	11188993.0
2009-02-06 09:00:00	SPY	ETF	85.08	85.2	84.76	84.84	2400985.0
2009-02-06 09:30:00	SPY	ETF	84.86	86.32	84.68	86.17	51537583.0
2009-02-06 10:00:00	SPY	ETF	86.18	87.0069	85.79	86.04	27942301.0
2009-02-06 10:30:00	SPY	ETF	86.05	86.37	85.82	86.13	16317341.0
2009-02-06 11:00:00	SPY	ETF	86.14	86.62	86.13	86.41	19485242.0
2009-02-06 11:30:00	SPY	ETF	86.42	86.65	86.28	86.52	11735428.0
2009-02-06 12:00:00	SPY	ETF	86.52	86.55	86.15	86.22	15072354.0
2009-02-06 12:30:00	SPY	ETF	86.22	86.61	86.19	86.49	12421672.0
2009-02-06 13:00:00	SPY	ETF	86.4818	87.15	86.38	87.05	18819709.0
2009-02-06 13:30:00	SPY	ETF	87.05	87.27	87.04	87.13	19221850.0
2009-02-06 14:00:00	SPY	ETF	87.13	87.15	86.7	86.97	22139687.0
2009-02-06 14:30:00	SPY	ETF	86.97	87.28	86.66	86.86	23596850.0
2009-02-06 15:00:00	SPY	ETF	86.86	86.9	86.41	86.79	27336246.0
2009-02-06 15:30:00	SPY	ETF	86.77	87.34	86.6	86.96	48297290.0
2009-02-06 16:00:00	SPY	ETF	86.99	87.32	86.89	87.11	9597359.0
2009-02-06 16:30:00	SPY	ETF	87.12	87.23	87.0	87.2	6167234.0
2009-02-06 17:00:00	SPY	ETF	87.18	87.3	87.1	87.17	2393933.0
2009-02-06 17:30:00	SPY	ETF	87.18	87.35	87.15	87.3	142173.0
2009-02-06 18:00:00	SPY	ETF	87.33	87.7	87.2	87.69	132883.0
2009-02-06 18:30:00	SPY	ETF	87.67	87.74	87.46	87.67	74848.0
2009-02-06 19:00:00	SPY	ETF	87.65	87.68	87.55	87.6	26259.0
2009-02-06 19:30:00	SPY	ETF	87.6	87.67	87.58	87.59	36138.0
2009-02-06 06:30:00	QQQ	ETF	30.61	30.61	30.61	30.61	200.0
2009-02-06 07:00:00	QQQ	ETF	30.63	30.63	30.55	30.56	85189.0
2009-02-06 07:30:00	QQQ	ETF	30.57	30.57	30.49	30.56	40928.0
2009-02-06 08:00:00	QQQ	ETF	30.55	30.57	30.41	30.52	341598.0
2009-02-06 08:30:00	QQQ	ETF	30.46	30.74	30.46	30.69	3020801.0
2009-02-06 09:00:00	QQQ	ETF	30.68	30.76	30.64	30.71	933450.0
2009-02-06 09:30:00	QQQ	ETF	30.71	31.22	30.58	31.159	35308826.0
2009-02-06 10:00:00	QQQ	ETF	31.16	31.21	30.96	31.06	10770667.0
2009-02-06 10:30:00	QQQ	ETF	31.06	31.17	30.96	31.1	7693312.0
2009-02-06 11:00:00	QQQ	ETF	31.1099	31.28	31.1	31.1899	8558701.0
2009-02-06 11:30:00	QQQ	ETF	31.18	31.3	31.16	31.26	5863249.0
2009-02-06 12:00:00	QQQ	ETF	31.26	31.26	31.12	31.14	6090200.0
2009-02-06 12:30:00	QQQ	ETF	31.14	31.3	31.14	31.25	6848199.0
2009-02-06 13:00:00	QQQ	ETF	31.25	31.49	31.21	31.42	11142933.0
2009-02-06 13:30:00	QQQ	ETF	31.43	31.51	31.42	31.461	8031086.0
2009-02-06 14:00:00	QQQ	ETF	31.47	31.47	31.33	31.42	11894866.0
2009-02-06 14:30:00	QQQ	ETF	31.42	31.51	31.3	31.38	9531871.0
2009-02-06 15:00:00	QQQ	ETF	31.39	31.4	31.2	31.33	15156571.0
2009-02-06 15:30:00	QQQ	ETF	31.33	31.51	31.325	31.36	17077384.0

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

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