PREVIEW / etf_30min / 2008-06-26

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-26.parquet
  size:    179 KB
  rows:    6,143

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-06-26 04:00:00	SPY	ETF	131.4	131.4	131.25	131.25	300.0
2008-06-26 05:00:00	SPY	ETF	131.22	131.22	131.16	131.16	3700.0
2008-06-26 05:30:00	SPY	ETF	131.16	131.16	131.05	131.12	1000.0
2008-06-26 06:00:00	SPY	ETF	131.2	131.26	131.05	131.05	79700.0
2008-06-26 06:30:00	SPY	ETF	131.14	131.4	131.14	131.4	250950.0
2008-06-26 07:00:00	SPY	ETF	131.34	131.49	131.29	131.33	461150.0
2008-06-26 07:30:00	SPY	ETF	131.31	131.38	130.55	130.69	1528971.0
2008-06-26 08:00:00	SPY	ETF	130.7	131.25	130.61	130.74	2660732.0
2008-06-26 08:30:00	SPY	ETF	130.73	131.35	130.37	130.53	4459482.0
2008-06-26 09:00:00	SPY	ETF	130.51	130.6	130.25	130.58	2389793.0
2008-06-26 09:30:00	SPY	ETF	130.57	130.69	130.2	130.5	29749699.0
2008-06-26 10:00:00	SPY	ETF	130.5	131.42	130.09	130.49	28762355.0
2008-06-26 10:30:00	SPY	ETF	130.48	130.55	129.5	129.55	30134854.0
2008-06-26 11:00:00	SPY	ETF	129.55	129.81	129.36	129.49	20822827.0
2008-06-26 11:30:00	SPY	ETF	129.49	129.9	129.46	129.748	17194517.0
2008-06-26 12:00:00	SPY	ETF	129.77	129.79	129.23	129.27	15957416.0
2008-06-26 12:30:00	SPY	ETF	129.28	129.31	129.0	129.21	16665345.0
2008-06-26 13:00:00	SPY	ETF	129.21	129.44	128.86	128.94	11899690.0
2008-06-26 13:30:00	SPY	ETF	128.94	129.48	128.9	129.33	10552900.0
2008-06-26 14:00:00	SPY	ETF	129.33	129.57	128.8	129.04	21317465.0
2008-06-26 14:30:00	SPY	ETF	129.04	129.12	128.5	128.58	18364552.0
2008-06-26 15:00:00	SPY	ETF	128.58	129.04	128.53	128.89	20350255.0
2008-06-26 15:30:00	SPY	ETF	128.89	129.07	128.17	128.21	34586381.0
2008-06-26 16:00:00	SPY	ETF	128.21	128.38	128.08	128.2	4240404.0
2008-06-26 16:30:00	SPY	ETF	128.2	128.32	128.15	128.21	1361267.0
2008-06-26 17:00:00	SPY	ETF	128.24	128.37	128.21	128.27	69266.0
2008-06-26 17:30:00	SPY	ETF	128.26	128.3	128.21	128.27	42350.0
2008-06-26 18:00:00	SPY	ETF	128.28	128.34	128.28	128.34	49277.0
2008-06-26 18:30:00	SPY	ETF	128.34	128.37	128.32	128.36	42272.0
2008-06-26 19:00:00	SPY	ETF	128.36	128.38	128.31	128.32	28500.0
2008-06-26 19:30:00	SPY	ETF	128.33	128.35	128.23	128.26	29240.0
2008-06-26 04:30:00	QQQ	ETF	47.14	47.14	47.12	47.12	2000.0
2008-06-26 05:00:00	QQQ	ETF	47.12	47.12	47.07	47.07	500.0
2008-06-26 05:30:00	QQQ	ETF	47.06	47.06	47.06	47.06	100.0
2008-06-26 06:00:00	QQQ	ETF	47.08	47.08	47.05	47.05	26100.0
2008-06-26 06:30:00	QQQ	ETF	47.03	47.05	47.03	47.03	50500.0
2008-06-26 07:00:00	QQQ	ETF	47.04	47.06	47.0	47.02	22778.0
2008-06-26 07:30:00	QQQ	ETF	47.01	47.02	46.71	46.78	454415.0
2008-06-26 08:00:00	QQQ	ETF	46.78	47.01	46.71	46.79	1308730.0
2008-06-26 08:30:00	QQQ	ETF	46.78	46.79	46.6	46.62	2314205.0
2008-06-26 09:00:00	QQQ	ETF	46.62	46.72	46.51	46.71	1888892.0
2008-06-26 09:30:00	QQQ	ETF	46.72	46.72	46.4	46.5	17708930.0
2008-06-26 10:00:00	QQQ	ETF	46.51	46.62	46.3	46.48	15459503.0
2008-06-26 10:30:00	QQQ	ETF	46.48	46.49	46.05	46.1	17654356.0
2008-06-26 11:00:00	QQQ	ETF	46.1	46.18	46.03	46.11	9257444.0
2008-06-26 11:30:00	QQQ	ETF	46.1001	46.27	46.0901	46.1801	5674109.0
2008-06-26 12:00:00	QQQ	ETF	46.182	46.19	46.02	46.08	5721019.0
2008-06-26 12:30:00	QQQ	ETF	46.08	46.15	45.99	46.1	9874734.0
2008-06-26 13:00:00	QQQ	ETF	46.1001	46.17	45.9	45.93	7335891.0
2008-06-26 13:30:00	QQQ	ETF	45.92	46.06	45.86	46.02	8969246.0

> showing 50 of 6,143 rows — these rows as CSV

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