PREVIEW / etf_30min / 2008-08-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-14.parquet
  size:    169 KB
  rows:    5,928

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
2008-08-14 05:30:00	SPY	ETF	128.97	129.07	128.97	129.05	4000.0
2008-08-14 06:00:00	SPY	ETF	128.92	129.02	128.89	129.0	14700.0
2008-08-14 06:30:00	SPY	ETF	129.0	129.07	128.95	129.0	37300.0
2008-08-14 07:00:00	SPY	ETF	129.03	129.15	128.97	129.06	150208.0
2008-08-14 07:30:00	SPY	ETF	129.03	129.12	129.03	129.03	249702.0
2008-08-14 08:00:00	SPY	ETF	129.05	129.15	128.96	129.1	1550440.0
2008-08-14 08:30:00	SPY	ETF	129.0	129.1	127.86	127.96	8351829.0
2008-08-14 09:00:00	SPY	ETF	127.97	128.13	127.8	127.84	2135021.0
2008-08-14 09:30:00	SPY	ETF	127.84	128.5	127.75	128.45	24209548.0
2008-08-14 10:00:00	SPY	ETF	128.45	128.93	128.17	128.93	20753032.0
2008-08-14 10:30:00	SPY	ETF	128.93	129.55	128.84	129.35	26039045.0
2008-08-14 11:00:00	SPY	ETF	129.355	129.87	129.26	129.58	17844719.0
2008-08-14 11:30:00	SPY	ETF	129.58	129.69	129.36	129.61	8099737.0
2008-08-14 12:00:00	SPY	ETF	129.61	129.83	129.48	129.53	14167857.0
2008-08-14 12:30:00	SPY	ETF	129.53	130.28	129.49	130.0	18562376.0
2008-08-14 13:00:00	SPY	ETF	130.0	130.1	129.79	129.8	7625511.0
2008-08-14 13:30:00	SPY	ETF	129.81	130.0	129.47	129.73	10647328.0
2008-08-14 14:00:00	SPY	ETF	129.73	129.97	129.6	129.7	13911326.0
2008-08-14 14:30:00	SPY	ETF	129.71	129.75	129.2	129.35	14014187.0
2008-08-14 15:00:00	SPY	ETF	129.35	129.51	129.1	129.2	20445255.0
2008-08-14 15:30:00	SPY	ETF	129.21	129.59	129.17	129.54	20853448.0
2008-08-14 16:00:00	SPY	ETF	129.52	129.79	129.0	129.6	7812917.0
2008-08-14 16:30:00	SPY	ETF	129.6	129.76	129.54	129.74	317690.0
2008-08-14 17:00:00	SPY	ETF	129.72	129.84	129.72	129.79	50660.0
2008-08-14 17:30:00	SPY	ETF	129.79	129.79	129.75	129.75	17615.0
2008-08-14 18:00:00	SPY	ETF	129.79	129.82	129.78	129.82	36405.0
2008-08-14 18:30:00	SPY	ETF	129.82	129.85	129.82	129.85	44612.0
2008-08-14 19:30:00	SPY	ETF	129.84	129.86	129.81	129.84	24440.0
2008-08-14 06:30:00	QQQ	ETF	47.79	47.82	47.78	47.81	18500.0
2008-08-14 07:00:00	QQQ	ETF	47.8	47.86	47.8	47.81	9400.0
2008-08-14 07:30:00	QQQ	ETF	47.83	47.87	47.79	47.79	97090.0
2008-08-14 08:00:00	QQQ	ETF	47.8	47.85	47.77	47.8	760654.0
2008-08-14 08:30:00	QQQ	ETF	47.79	47.79	47.51	47.54	1828484.0
2008-08-14 09:00:00	QQQ	ETF	47.54	47.59	47.51	47.53	1576093.0
2008-08-14 09:30:00	QQQ	ETF	47.54	47.98	47.49	47.98	25554070.0
2008-08-14 10:00:00	QQQ	ETF	47.98	48.04	47.8	48.02	12817990.0
2008-08-14 10:30:00	QQQ	ETF	48.02	48.29	47.981	48.16	18056398.0
2008-08-14 11:00:00	QQQ	ETF	48.16	48.27	48.12	48.18	8513655.0
2008-08-14 11:30:00	QQQ	ETF	48.18	48.25	48.14	48.23	6141930.0
2008-08-14 12:00:00	QQQ	ETF	48.23	48.32	48.2	48.21	7901621.0
2008-08-14 12:30:00	QQQ	ETF	48.2097	48.45	48.19	48.36	12918112.0
2008-08-14 13:00:00	QQQ	ETF	48.36	48.46	48.32	48.33	5593911.0
2008-08-14 13:30:00	QQQ	ETF	48.33	48.3378	48.2	48.29	8808509.0
2008-08-14 14:00:00	QQQ	ETF	48.29	48.41	48.25	48.318	9013597.0
2008-08-14 14:30:00	QQQ	ETF	48.32	48.34	48.14	48.22	8263957.0
2008-08-14 15:00:00	QQQ	ETF	48.21	48.31	48.1	48.24	9665501.0
2008-08-14 15:30:00	QQQ	ETF	48.24	48.36	48.22	48.29	12090099.0
2008-08-14 16:00:00	QQQ	ETF	48.289	48.36	48.1835	48.3	1832847.0
2008-08-14 16:30:00	QQQ	ETF	48.3	48.33	48.26	48.32	212010.0
2008-08-14 17:00:00	QQQ	ETF	48.33	48.36	48.31	48.34	576046.0

> showing 50 of 5,928 rows — these rows as CSV

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