PREVIEW / etf_30min / 2009-04-01

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-01.parquet
  size:    207 KB
  rows:    6,828

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
2009-04-01 04:00:00	SPY	ETF	78.78	78.88	78.75	78.88	400.0
2009-04-01 04:30:00	SPY	ETF	78.84	78.84	78.84	78.84	3100.0
2009-04-01 05:00:00	SPY	ETF	78.9	79.15	78.9	79.15	26500.0
2009-04-01 05:30:00	SPY	ETF	79.06	79.06	79.06	79.06	1000.0
2009-04-01 06:00:00	SPY	ETF	79.19	79.22	79.19	79.22	20000.0
2009-04-01 06:30:00	SPY	ETF	79.15	79.15	79.05	79.05	4000.0
2009-04-01 07:00:00	SPY	ETF	79.05	79.44	79.05	79.38	642975.0
2009-04-01 07:30:00	SPY	ETF	79.4	79.55	79.13	79.14	400528.0
2009-04-01 08:00:00	SPY	ETF	79.14	79.52	78.74	78.74	3734105.0
2009-04-01 08:30:00	SPY	ETF	78.74	79.52	78.4	78.82	1909602.0
2009-04-01 09:00:00	SPY	ETF	78.8	79.22	78.53	78.54	2178443.0
2009-04-01 09:30:00	SPY	ETF	78.53	78.9	78.33	78.9	31551643.0
2009-04-01 10:00:00	SPY	ETF	78.8901	80.03	78.8901	79.7899	45701981.0
2009-04-01 10:30:00	SPY	ETF	79.79	80.41	79.62	80.14	39820710.0
2009-04-01 11:00:00	SPY	ETF	80.13	80.35	79.89	80.29	23260689.0
2009-04-01 11:30:00	SPY	ETF	80.29	80.6	80.2	80.51	17341682.0
2009-04-01 12:00:00	SPY	ETF	80.51	80.92	80.495	80.66	19356411.0
2009-04-01 12:30:00	SPY	ETF	80.66	80.77	80.29	80.37	10557034.0
2009-04-01 13:00:00	SPY	ETF	80.37	80.63	80.18	80.55	12942234.0
2009-04-01 13:30:00	SPY	ETF	80.55	81.01	80.36	80.96	17622347.0
2009-04-01 14:00:00	SPY	ETF	80.96	81.29	80.35	80.98	19747614.0
2009-04-01 14:30:00	SPY	ETF	80.98	81.25	80.82	81.0175	20050679.0
2009-04-01 15:00:00	SPY	ETF	81.0175	81.08	80.18	80.65	35884443.0
2009-04-01 15:30:00	SPY	ETF	80.6599	81.42	78.4	81.03	44515695.0
2009-04-01 16:00:00	SPY	ETF	81.03	81.36	79.3	81.29	11387202.0
2009-04-01 16:30:00	SPY	ETF	81.29	81.35	79.806	81.26	3029552.0
2009-04-01 17:00:00	SPY	ETF	81.26	81.39	81.22	81.39	249172.0
2009-04-01 17:30:00	SPY	ETF	81.37	81.4	81.32	81.39	37670.0
2009-04-01 18:00:00	SPY	ETF	81.37	81.39	81.29	81.31	176386.0
2009-04-01 18:30:00	SPY	ETF	81.31	81.35	81.29	81.29	105900.0
2009-04-01 19:00:00	SPY	ETF	81.29	81.31	81.25	81.26	26929.0
2009-04-01 19:30:00	SPY	ETF	81.28	81.3	81.25	81.29	82191.0
2009-04-01 04:00:00	QQQ	ETF	30.07	30.15	30.07	30.15	685.0
2009-04-01 04:30:00	QQQ	ETF	30.16	30.16	30.16	30.16	300.0
2009-04-01 05:00:00	QQQ	ETF	30.2	30.2	30.2	30.2	100.0
2009-04-01 06:00:00	QQQ	ETF	30.21	30.21	30.21	30.21	200.0
2009-04-01 06:30:00	QQQ	ETF	30.16	30.16	30.15	30.15	800.0
2009-04-01 07:00:00	QQQ	ETF	30.15	30.26	30.15	30.23	270758.0
2009-04-01 07:30:00	QQQ	ETF	30.24	30.25	30.14	30.14	394396.0
2009-04-01 08:00:00	QQQ	ETF	30.14	30.32	30.0	30.0	2724702.0
2009-04-01 08:30:00	QQQ	ETF	30.0	30.05	29.85	30.0	610877.0
2009-04-01 09:00:00	QQQ	ETF	29.99	30.07	29.93	29.94	1497585.0
2009-04-01 09:30:00	QQQ	ETF	29.94	29.97	29.79	29.94	14180331.0
2009-04-01 10:00:00	QQQ	ETF	29.9401	30.37	29.9401	30.26	20262674.0
2009-04-01 10:30:00	QQQ	ETF	30.26	30.58	30.22	30.51	11847857.0
2009-04-01 11:00:00	QQQ	ETF	30.5	30.54	30.4	30.52	8832019.0
2009-04-01 11:30:00	QQQ	ETF	30.5299	30.67	30.49	30.64	6951647.0
2009-04-01 12:00:00	QQQ	ETF	30.64	30.76	30.5	30.67	5700127.0
2009-04-01 12:30:00	QQQ	ETF	30.6799	30.72	30.54	30.57	4664792.0
2009-04-01 13:00:00	QQQ	ETF	30.57	30.66	30.5	30.63	3919264.0

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

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