PREVIEW / etf_30min / 2010-12-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-09.parquet
  size:    264 KB
  rows:    8,927

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-12-09 04:00:00	SPY	ETF	123.86	124.04	123.86	123.91	8500.0
2010-12-09 04:30:00	SPY	ETF	123.91	123.91	123.7	123.7	2300.0
2010-12-09 05:00:00	SPY	ETF	123.63	123.79	123.6	123.79	1700.0
2010-12-09 05:30:00	SPY	ETF	123.64	123.69	123.58	123.69	1500.0
2010-12-09 06:00:00	SPY	ETF	123.71	123.77	123.69	123.74	37000.0
2010-12-09 06:30:00	SPY	ETF	123.77	123.77	123.69	123.75	41300.0
2010-12-09 07:00:00	SPY	ETF	123.76	123.83	123.74	123.81	67481.0
2010-12-09 07:30:00	SPY	ETF	123.83	123.84	123.73	123.77	80280.0
2010-12-09 08:00:00	SPY	ETF	123.77	123.83	123.72	123.8	641774.0
2010-12-09 08:30:00	SPY	ETF	123.82	124.09	123.82	123.97	1460272.0
2010-12-09 09:00:00	SPY	ETF	123.97	124.05	123.96	123.98	714167.0
2010-12-09 09:30:00	SPY	ETF	123.97	124.02	123.62	123.87	18356887.0
2010-12-09 10:00:00	SPY	ETF	123.87	123.94	123.46	123.57	10718065.0
2010-12-09 10:30:00	SPY	ETF	123.57	123.65	123.25	123.38	9092688.0
2010-12-09 11:00:00	SPY	ETF	123.37	123.6	123.34	123.46	6057015.0
2010-12-09 11:30:00	SPY	ETF	123.46	123.54	123.15	123.37	9612064.0
2010-12-09 12:00:00	SPY	ETF	123.37	123.43	123.33	123.39	5233620.0
2010-12-09 12:30:00	SPY	ETF	123.38	123.52	123.33	123.46	3447163.0
2010-12-09 13:00:00	SPY	ETF	123.47	123.73	123.42	123.6	7611202.0
2010-12-09 13:30:00	SPY	ETF	123.61	123.66	123.48	123.6	6324964.0
2010-12-09 14:00:00	SPY	ETF	123.61	123.62	123.37	123.48	5374347.0
2010-12-09 14:30:00	SPY	ETF	123.48	123.58	123.41	123.57	4397185.0
2010-12-09 15:00:00	SPY	ETF	123.57	123.68	123.51	123.605	7182044.0
2010-12-09 15:30:00	SPY	ETF	123.6	123.88	123.58	123.79	17525097.0
2010-12-09 16:00:00	SPY	ETF	123.79	123.9776	123.3168	123.75	7261825.0
2010-12-09 16:30:00	SPY	ETF	123.75	123.84	123.51	123.73	327970.0
2010-12-09 17:00:00	SPY	ETF	123.74	123.76	123.71	123.73	34849.0
2010-12-09 17:30:00	SPY	ETF	123.75	123.75	123.7	123.73	56391.0
2010-12-09 18:00:00	SPY	ETF	123.73	123.97	123.73	123.95	212231.0
2010-12-09 18:30:00	SPY	ETF	123.95	124.07	123.95	124.01	163688.0
2010-12-09 19:00:00	SPY	ETF	124.02	124.06	123.82	123.83	87329.0
2010-12-09 19:30:00	SPY	ETF	123.84	123.95	123.83	123.9	112167.0
2010-12-09 05:00:00	QQQ	ETF	54.27	54.27	54.21	54.21	2000.0
2010-12-09 07:00:00	QQQ	ETF	54.24	54.28	54.23	54.28	94920.0
2010-12-09 07:30:00	QQQ	ETF	54.29	54.29	54.24	54.26	7139.0
2010-12-09 08:00:00	QQQ	ETF	54.26	54.29	54.24	54.26	117004.0
2010-12-09 08:30:00	QQQ	ETF	54.29	54.39	54.28	54.37	363030.0
2010-12-09 09:00:00	QQQ	ETF	54.37	54.41	54.37	54.41	256399.0
2010-12-09 09:30:00	QQQ	ETF	54.41	54.44	54.19	54.3099	8648422.0
2010-12-09 10:00:00	QQQ	ETF	54.3	54.33	54.14	54.17	4343776.0
2010-12-09 10:30:00	QQQ	ETF	54.179	54.22	53.98	54.05	4407651.0
2010-12-09 11:00:00	QQQ	ETF	54.048	54.15	54.02	54.1	3002592.0
2010-12-09 11:30:00	QQQ	ETF	54.11	54.15	53.95	54.06	4241509.0
2010-12-09 12:00:00	QQQ	ETF	54.06	54.11	54.04	54.09	829350.0
2010-12-09 12:30:00	QQQ	ETF	54.09	54.15	54.06	54.12	523179.0
2010-12-09 13:00:00	QQQ	ETF	54.12	54.2	54.09	54.15	3009052.0
2010-12-09 13:30:00	QQQ	ETF	54.15	54.18	54.1	54.17	792838.0
2010-12-09 14:00:00	QQQ	ETF	54.16	54.17	54.0401	54.09	1625394.0
2010-12-09 14:30:00	QQQ	ETF	54.09	54.1	54.02	54.09	1657682.0
2010-12-09 15:00:00	QQQ	ETF	54.09	54.14	54.061	54.085	1085069.0

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

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