PREVIEW / etf_30min / 2010-02-22

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-22.parquet
  size:    239 KB
  rows:    8,067

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
2010-02-22 04:00:00	SPY	ETF	111.19	111.19	111.16	111.16	300.0
2010-02-22 04:30:00	SPY	ETF	111.39	111.39	111.24	111.24	300.0
2010-02-22 05:00:00	SPY	ETF	111.32	111.32	111.32	111.32	100.0
2010-02-22 05:30:00	SPY	ETF	111.39	111.39	111.24	111.32	20900.0
2010-02-22 06:00:00	SPY	ETF	111.32	111.35	111.29	111.35	20800.0
2010-02-22 06:30:00	SPY	ETF	111.29	111.36	111.26	111.26	8800.0
2010-02-22 07:00:00	SPY	ETF	111.32	111.54	111.32	111.4	273327.0
2010-02-22 07:30:00	SPY	ETF	111.4	111.73	111.4	111.67	450037.0
2010-02-22 08:00:00	SPY	ETF	111.66	111.7	111.03	111.54	800815.0
2010-02-22 08:30:00	SPY	ETF	111.53	111.59	111.36	111.53	1006859.0
2010-02-22 09:00:00	SPY	ETF	111.53	111.56	111.49	111.54	754941.0
2010-02-22 09:30:00	SPY	ETF	111.55	111.58	111.01	111.24	20703476.0
2010-02-22 10:00:00	SPY	ETF	111.23	111.26	110.83	111.1799	16182197.0
2010-02-22 10:30:00	SPY	ETF	111.17	111.33	111.06	111.06	9179777.0
2010-02-22 11:00:00	SPY	ETF	111.07	111.15	110.92	111.01	8614723.0
2010-02-22 11:30:00	SPY	ETF	111.0	111.14	110.9	111.0	8015502.0
2010-02-22 12:00:00	SPY	ETF	111.0	111.13	110.94	111.029	5706320.0
2010-02-22 12:30:00	SPY	ETF	111.02	111.4265	111.02	111.195	5114143.0
2010-02-22 13:00:00	SPY	ETF	111.195	111.22	111.05	111.115	3716396.0
2010-02-22 13:30:00	SPY	ETF	111.1198	111.33	111.08	111.13	6351885.0
2010-02-22 14:00:00	SPY	ETF	111.14	111.36	111.13	111.3	5799288.0
2010-02-22 14:30:00	SPY	ETF	111.3	111.44	111.28	111.39	6182097.0
2010-02-22 15:00:00	SPY	ETF	111.38	111.5	111.33	111.41	5720140.0
2010-02-22 15:30:00	SPY	ETF	111.42	111.43	110.96	111.13	19132356.0
2010-02-22 16:00:00	SPY	ETF	111.14	111.3652	110.99	111.18	5148513.0
2010-02-22 16:30:00	SPY	ETF	111.17	111.2322	111.12	111.12	3008455.0
2010-02-22 17:00:00	SPY	ETF	111.14	111.2	111.12	111.19	165800.0
2010-02-22 17:30:00	SPY	ETF	111.17	111.21	111.12	111.13	54777.0
2010-02-22 18:00:00	SPY	ETF	111.13	111.16	111.11	111.15	58152.0
2010-02-22 18:30:00	SPY	ETF	111.13	111.18	111.13	111.18	2200.0
2010-02-22 19:00:00	SPY	ETF	111.15	111.26	111.14	111.21	34101.0
2010-02-22 19:30:00	SPY	ETF	111.19	111.21	111.12	111.12	103406.0
2010-02-22 05:30:00	QQQ	ETF	44.97	44.97	44.97	44.97	100.0
2010-02-22 06:00:00	QQQ	ETF	44.93	44.93	44.93	44.93	2844.0
2010-02-22 06:30:00	QQQ	ETF	44.94	44.97	44.94	44.97	3924.0
2010-02-22 07:00:00	QQQ	ETF	44.97	45.02	44.97	45.0	7176.0
2010-02-22 07:30:00	QQQ	ETF	44.98	45.1	44.98	45.07	135120.0
2010-02-22 08:00:00	QQQ	ETF	45.07	45.09	45.02	45.03	170364.0
2010-02-22 08:30:00	QQQ	ETF	45.03	45.09	44.83	45.06	199393.0
2010-02-22 09:00:00	QQQ	ETF	45.05	45.07	45.0	45.01	163527.0
2010-02-22 09:30:00	QQQ	ETF	45.01	45.03	44.67	44.74	11683574.0
2010-02-22 10:00:00	QQQ	ETF	44.73	44.79	44.56	44.76	12923098.0
2010-02-22 10:30:00	QQQ	ETF	44.76	44.81	44.71	44.72	5317207.0
2010-02-22 11:00:00	QQQ	ETF	44.71	44.75	44.64	44.66	3058723.0
2010-02-22 11:30:00	QQQ	ETF	44.67	44.68	44.6	44.63	3589661.0
2010-02-22 12:00:00	QQQ	ETF	44.63	44.67	44.61	44.65	1921188.0
2010-02-22 12:30:00	QQQ	ETF	44.65	44.735	44.64	44.71	2403814.0
2010-02-22 13:00:00	QQQ	ETF	44.711	44.72	44.63	44.7	1519963.0
2010-02-22 13:30:00	QQQ	ETF	44.7	44.79	44.65	44.7101	2933914.0
2010-02-22 14:00:00	QQQ	ETF	44.72	44.8	44.7	44.7699	1966348.0

> showing 50 of 8,067 rows — these rows as CSV

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