PREVIEW / etf_30min / 2010-10-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-26.parquet
  size:    259 KB
  rows:    8,768

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-10-26 04:00:00	SPY	ETF	117.18	118.5	117.18	118.48	4200.0
2010-10-26 04:30:00	SPY	ETF	118.56	118.66	118.56	118.66	900.0
2010-10-26 05:00:00	SPY	ETF	118.42	118.47	118.41	118.47	7750.0
2010-10-26 05:30:00	SPY	ETF	118.39	118.56	118.39	118.56	44780.0
2010-10-26 06:00:00	SPY	ETF	118.6	118.72	118.56	118.72	5225.0
2010-10-26 06:30:00	SPY	ETF	118.7	118.78	118.68	118.75	3750.0
2010-10-26 07:00:00	SPY	ETF	118.7	118.73	118.45	118.53	439200.0
2010-10-26 07:30:00	SPY	ETF	118.53	118.56	118.29	118.44	461005.0
2010-10-26 08:00:00	SPY	ETF	118.44	118.58	118.2	118.29	1149638.0
2010-10-26 08:30:00	SPY	ETF	118.29	118.38	118.2	118.25	1037548.0
2010-10-26 09:00:00	SPY	ETF	118.25	118.3	118.02	118.1	1387588.0
2010-10-26 09:30:00	SPY	ETF	118.1	118.23	117.87	118.15	20021140.0
2010-10-26 10:00:00	SPY	ETF	118.15	118.72	118.13	118.54	17144686.0
2010-10-26 10:30:00	SPY	ETF	118.545	118.63	118.32	118.59	10043234.0
2010-10-26 11:00:00	SPY	ETF	118.59	118.76	118.3	118.65	13952969.0
2010-10-26 11:30:00	SPY	ETF	118.66	118.67	118.51	118.67	5871309.0
2010-10-26 12:00:00	SPY	ETF	118.67	118.78	118.6	118.67	10089572.0
2010-10-26 12:30:00	SPY	ETF	118.6703	118.71	118.54	118.61	5542416.0
2010-10-26 13:00:00	SPY	ETF	118.619	118.79	118.52	118.54	5719550.0
2010-10-26 13:30:00	SPY	ETF	118.5416	118.69	118.38	118.42	6106723.0
2010-10-26 14:00:00	SPY	ETF	118.41	118.5	118.23	118.45	12344325.0
2010-10-26 14:30:00	SPY	ETF	118.46	118.64	118.34	118.5238	8446461.0
2010-10-26 15:00:00	SPY	ETF	118.52	118.84	118.51	118.69	8474953.0
2010-10-26 15:30:00	SPY	ETF	118.7	118.76	118.52	118.71	18545175.0
2010-10-26 16:00:00	SPY	ETF	118.7	118.9	118.275	118.84	7888509.0
2010-10-26 16:30:00	SPY	ETF	118.83	118.89	118.79	118.81	1523142.0
2010-10-26 17:00:00	SPY	ETF	118.82	118.83	118.76	118.82	63938.0
2010-10-26 17:30:00	SPY	ETF	118.82	118.85	118.79	118.84	33022.0
2010-10-26 18:00:00	SPY	ETF	118.8	118.84	118.73	118.77	39763.0
2010-10-26 18:30:00	SPY	ETF	118.8	118.83	118.78	118.78	13850.0
2010-10-26 19:00:00	SPY	ETF	118.78	118.83	118.78	118.8	6400.0
2010-10-26 19:30:00	SPY	ETF	118.82	118.87	118.8	118.86	45589.0
2010-10-26 04:30:00	QQQ	ETF	51.76	51.76	51.76	51.76	2100.0
2010-10-26 05:00:00	QQQ	ETF	51.7	51.7	51.7	51.7	1000.0
2010-10-26 05:30:00	QQQ	ETF	51.71	51.71	51.71	51.71	400.0
2010-10-26 07:00:00	QQQ	ETF	51.85	51.85	51.79	51.79	4613.0
2010-10-26 07:30:00	QQQ	ETF	51.78	51.78	51.68	51.72	17625.0
2010-10-26 08:00:00	QQQ	ETF	51.74	51.74	51.63	51.66	186278.0
2010-10-26 08:30:00	QQQ	ETF	51.66	51.71	51.63	51.64	183134.0
2010-10-26 09:00:00	QQQ	ETF	51.64	51.65	51.54	51.6	824389.0
2010-10-26 09:30:00	QQQ	ETF	51.61	51.63	51.42	51.55	7935592.0
2010-10-26 10:00:00	QQQ	ETF	51.55	51.95	51.54	51.87	7075510.0
2010-10-26 10:30:00	QQQ	ETF	51.87	51.93	51.78	51.92	5344823.0
2010-10-26 11:00:00	QQQ	ETF	51.91	52.04	51.82	51.99	6006174.0
2010-10-26 11:30:00	QQQ	ETF	51.98	52.02	51.92	52.02	1478484.0
2010-10-26 12:00:00	QQQ	ETF	52.02	52.11	51.98	52.07	2399720.0
2010-10-26 12:30:00	QQQ	ETF	52.0702	52.09	52.0	52.03	1414875.0
2010-10-26 13:00:00	QQQ	ETF	52.04	52.15	52.02	52.02	2917195.0
2010-10-26 13:30:00	QQQ	ETF	52.03	52.115	51.945	51.96	2585309.0
2010-10-26 14:00:00	QQQ	ETF	51.96	52.02	51.89	52.02	3235218.0

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

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