PREVIEW / etf_30min / 2010-02-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-09.parquet
  size:    252 KB
  rows:    8,433

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-09 04:00:00	SPY	ETF	106.89	107.12	106.89	107.1	17858.0
2010-02-09 04:30:00	SPY	ETF	107.12	107.14	106.93	106.94	5846.0
2010-02-09 05:00:00	SPY	ETF	106.87	106.96	106.83	106.96	17700.0
2010-02-09 05:30:00	SPY	ETF	106.91	106.95	106.75	106.8	13500.0
2010-02-09 06:00:00	SPY	ETF	106.77	106.77	106.57	106.63	1739.0
2010-02-09 06:30:00	SPY	ETF	106.73	106.79	106.6	106.79	125400.0
2010-02-09 07:00:00	SPY	ETF	106.7	106.94	106.7	106.84	270055.0
2010-02-09 07:30:00	SPY	ETF	106.85	107.16	106.81	106.98	613323.0
2010-02-09 08:00:00	SPY	ETF	107.04	107.15	106.89	107.02	1919186.0
2010-02-09 08:30:00	SPY	ETF	107.02	107.21	106.95	107.05	2470829.0
2010-02-09 09:00:00	SPY	ETF	107.04	107.16	106.94	107.13	2206059.0
2010-02-09 09:30:00	SPY	ETF	107.13	107.35	106.82	106.955	27991527.0
2010-02-09 10:00:00	SPY	ETF	106.95	107.44	106.81	107.1701	17826423.0
2010-02-09 10:30:00	SPY	ETF	107.17	107.25	106.73	106.79	19465055.0
2010-02-09 11:00:00	SPY	ETF	106.78	106.78	106.27	106.38	29863111.0
2010-02-09 11:30:00	SPY	ETF	106.39	107.63	106.27	107.33	49966704.0
2010-02-09 12:00:00	SPY	ETF	107.322	108.15	107.3	107.89	27582271.0
2010-02-09 12:30:00	SPY	ETF	107.89	108.05	107.11	107.521	43525158.0
2010-02-09 13:00:00	SPY	ETF	107.53	107.76	107.33	107.42	11543888.0
2010-02-09 13:30:00	SPY	ETF	107.43	107.65	107.33	107.54	10076396.0
2010-02-09 14:00:00	SPY	ETF	107.53	107.62	107.23	107.38	10009944.0
2010-02-09 14:30:00	SPY	ETF	107.38	107.58	107.1	107.2	19076552.0
2010-02-09 15:00:00	SPY	ETF	107.205	107.68	107.17	107.6	16859297.0
2010-02-09 15:30:00	SPY	ETF	107.59	107.89	107.02	107.24	28344333.0
2010-02-09 16:00:00	SPY	ETF	107.23	107.86	106.3	107.13	11164168.0
2010-02-09 16:30:00	SPY	ETF	107.15	107.25	105.8653	107.19	3882369.0
2010-02-09 17:00:00	SPY	ETF	107.19	107.23	107.14	107.2	32888.0
2010-02-09 17:30:00	SPY	ETF	107.18	107.21	107.17	107.21	20600.0
2010-02-09 18:00:00	SPY	ETF	107.18	107.29	107.18	107.26	52760.0
2010-02-09 18:30:00	SPY	ETF	107.28	107.28	107.23	107.23	9400.0
2010-02-09 19:00:00	SPY	ETF	107.24	107.29	107.1	107.29	35369.0
2010-02-09 19:30:00	SPY	ETF	107.26	107.31	107.24	107.29	24120.0
2010-02-09 04:00:00	QQQ	ETF	43.05	43.13	43.05	43.12	2900.0
2010-02-09 04:30:00	QQQ	ETF	43.1	43.1	43.1	43.1	500.0
2010-02-09 05:00:00	QQQ	ETF	43.04	43.04	43.03	43.03	4600.0
2010-02-09 06:30:00	QQQ	ETF	43.0	43.88	42.96	43.0	160939.0
2010-02-09 07:00:00	QQQ	ETF	42.97	43.06	42.96	43.04	32769.0
2010-02-09 07:30:00	QQQ	ETF	43.05	43.15	43.05	43.09	69418.0
2010-02-09 08:00:00	QQQ	ETF	43.07	43.13	43.05	43.09	463064.0
2010-02-09 08:30:00	QQQ	ETF	43.1	43.17	43.1	43.13	350377.0
2010-02-09 09:00:00	QQQ	ETF	43.12	43.19	42.67	43.17	551309.0
2010-02-09 09:30:00	QQQ	ETF	43.16	43.24	43.0	43.08	10994820.0
2010-02-09 10:00:00	QQQ	ETF	43.07	43.27	43.01	43.16	8471658.0
2010-02-09 10:30:00	QQQ	ETF	43.16	43.2	42.98	42.99	6853693.0
2010-02-09 11:00:00	QQQ	ETF	42.99	43.0	42.76	42.81	9871982.0
2010-02-09 11:30:00	QQQ	ETF	42.81	43.26	42.77	43.18	16945396.0
2010-02-09 12:00:00	QQQ	ETF	43.18	43.51	43.16	43.4001	8419267.0
2010-02-09 12:30:00	QQQ	ETF	43.4	43.46	43.1	43.23	16345340.0
2010-02-09 13:00:00	QQQ	ETF	43.22	43.32	43.17	43.1901	3696463.0
2010-02-09 13:30:00	QQQ	ETF	43.19	43.3	43.16	43.24	3094833.0

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

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