PREVIEW / etf_30min / 2010-01-12

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-12.parquet
  size:    249 KB
  rows:    8,299

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-01-12 04:00:00	SPY	ETF	114.27	114.3	114.1	114.1	3250.0
2010-01-12 04:30:00	SPY	ETF	114.13	114.15	114.1	114.15	2380.0
2010-01-12 05:30:00	SPY	ETF	114.3	114.3	114.3	114.3	600.0
2010-01-12 06:00:00	SPY	ETF	114.32	114.32	113.77	113.9	56690.0
2010-01-12 06:30:00	SPY	ETF	113.9	114.02	113.87	113.93	26946.0
2010-01-12 07:00:00	SPY	ETF	113.91	114.05	113.88	113.99	112713.0
2010-01-12 07:30:00	SPY	ETF	113.98	114.03	113.87	113.98	232820.0
2010-01-12 08:00:00	SPY	ETF	113.98	114.02	113.77	113.8	2267644.0
2010-01-12 08:30:00	SPY	ETF	113.79	113.96	113.73	113.89	1614783.0
2010-01-12 09:00:00	SPY	ETF	113.88	114.73	113.83	113.96	1822267.0
2010-01-12 09:30:00	SPY	ETF	113.97	114.18	113.71	114.14	23609517.0
2010-01-12 10:00:00	SPY	ETF	114.1383	114.21	113.93	114.16	12757376.0
2010-01-12 10:30:00	SPY	ETF	114.17	114.21	114.0	114.13	9307578.0
2010-01-12 11:00:00	SPY	ETF	114.12	114.15	113.99	114.12	6652597.0
2010-01-12 11:30:00	SPY	ETF	114.11	114.17	113.87	113.895	8682861.0
2010-01-12 12:00:00	SPY	ETF	113.89	113.9	113.46	113.54	12776997.0
2010-01-12 12:30:00	SPY	ETF	113.54	113.57	113.29	113.335	11252047.0
2010-01-12 13:00:00	SPY	ETF	113.36	113.46	113.22	113.349	9115347.0
2010-01-12 13:30:00	SPY	ETF	113.35	113.54	113.32	113.5275	6382336.0
2010-01-12 14:00:00	SPY	ETF	113.52	113.54	113.4	113.4899	5765640.0
2010-01-12 14:30:00	SPY	ETF	113.49	113.68	113.33	113.63	8115483.0
2010-01-12 15:00:00	SPY	ETF	113.625	113.64	113.43	113.56	6810300.0
2010-01-12 15:30:00	SPY	ETF	113.56	113.69	113.29	113.66	18244551.0
2010-01-12 16:00:00	SPY	ETF	113.66	114.13	113.42	113.84	10446517.0
2010-01-12 16:30:00	SPY	ETF	113.85	114.7557	113.79	113.86	1348598.0
2010-01-12 17:00:00	SPY	ETF	113.86	113.87	113.81	113.83	71877.0
2010-01-12 17:30:00	SPY	ETF	113.84	113.86	113.82	113.84	15260.0
2010-01-12 18:00:00	SPY	ETF	113.83	113.84	113.79	113.83	65200.0
2010-01-12 18:30:00	SPY	ETF	113.81	113.84	113.81	113.84	22400.0
2010-01-12 19:00:00	SPY	ETF	113.85	114.01	113.83	114.0	206375.0
2010-01-12 19:30:00	SPY	ETF	114.02	114.08	113.96	113.96	43365.0
2010-01-12 04:00:00	QQQ	ETF	46.19	46.19	46.15	46.15	1678.0
2010-01-12 04:30:00	QQQ	ETF	46.08	46.08	46.06	46.06	5555.0
2010-01-12 05:00:00	QQQ	ETF	46.18	46.18	46.18	46.18	2200.0
2010-01-12 05:30:00	QQQ	ETF	46.19	46.19	46.17	46.17	3222.0
2010-01-12 06:00:00	QQQ	ETF	46.18	46.18	46.02	46.02	3796.0
2010-01-12 06:30:00	QQQ	ETF	46.02	46.03	45.99	46.03	30377.0
2010-01-12 07:00:00	QQQ	ETF	46.03	46.05	46.0	46.03	253736.0
2010-01-12 07:30:00	QQQ	ETF	46.02	46.07	46.02	46.07	92492.0
2010-01-12 08:00:00	QQQ	ETF	45.99	46.09	45.99	46.02	412196.0
2010-01-12 08:30:00	QQQ	ETF	46.02	46.08	46.0	46.07	266881.0
2010-01-12 09:00:00	QQQ	ETF	46.07	46.1	46.05	46.08	257039.0
2010-01-12 09:30:00	QQQ	ETF	46.08	46.14	45.82	45.96	14192620.0
2010-01-12 10:00:00	QQQ	ETF	45.96	46.03	45.92	45.9999	6073886.0
2010-01-12 10:30:00	QQQ	ETF	45.9999	46.07	45.93	46.01	6835216.0
2010-01-12 11:00:00	QQQ	ETF	46.01	46.02	45.93	45.96	4668717.0
2010-01-12 11:30:00	QQQ	ETF	45.97	45.99	45.87	45.92	5257914.0
2010-01-12 12:00:00	QQQ	ETF	45.91	45.93	45.62	45.66	7677456.0
2010-01-12 12:30:00	QQQ	ETF	45.66	45.69	45.54	45.59	7420483.0
2010-01-12 13:00:00	QQQ	ETF	45.6	45.64	45.53	45.6199	4987911.0

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

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