PREVIEW / etf_30min / 2007-11-12

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-12.parquet
  size:    148 KB
  rows:    5,339

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
2007-11-12 04:00:00	SPY	ETF	145.42	145.42	145.42	145.42	200.0
2007-11-12 05:00:00	SPY	ETF	145.66	145.66	145.66	145.66	500.0
2007-11-12 06:00:00	SPY	ETF	145.22	145.22	145.04	145.04	26100.0
2007-11-12 06:30:00	SPY	ETF	145.3	145.55	145.29	145.44	227400.0
2007-11-12 07:00:00	SPY	ETF	145.34	145.59	144.82	145.06	1527800.0
2007-11-12 07:30:00	SPY	ETF	145.05	145.37	145.0	145.33	788900.0
2007-11-12 08:00:00	SPY	ETF	145.29	145.52	144.6	145.18	530900.0
2007-11-12 08:30:00	SPY	ETF	145.16	145.49	145.16	145.38	747700.0
2007-11-12 09:00:00	SPY	ETF	145.38	145.42	145.19	145.2	741785.0
2007-11-12 09:30:00	SPY	ETF	145.21	145.98	144.74	145.63	39451064.0
2007-11-12 10:00:00	SPY	ETF	145.64	145.74	144.99	145.6	17175623.0
2007-11-12 10:30:00	SPY	ETF	145.6	146.18	145.48	146.1	20077623.0
2007-11-12 11:00:00	SPY	ETF	146.09	146.57	145.37	146.45	22361385.0
2007-11-12 11:30:00	SPY	ETF	146.45	146.51	145.75	145.91	12141818.0
2007-11-12 12:00:00	SPY	ETF	145.91	146.43	145.89	146.32	7771953.0
2007-11-12 12:30:00	SPY	ETF	146.32	146.61	145.97	146.03	5992511.0
2007-11-12 13:00:00	SPY	ETF	146.04	146.22	145.75	146.15	8465843.0
2007-11-12 13:30:00	SPY	ETF	146.16	146.16	145.17	145.41	17728313.0
2007-11-12 14:00:00	SPY	ETF	145.41	145.68	145.03	145.54	11404103.0
2007-11-12 14:30:00	SPY	ETF	145.56	146.19	145.51	145.78	13833124.0
2007-11-12 15:00:00	SPY	ETF	145.78	145.79	144.81	144.84	17467959.0
2007-11-12 15:30:00	SPY	ETF	144.83	145.23	143.93	143.99	31973866.0
2007-11-12 16:00:00	SPY	ETF	143.97	145.8618	143.62	143.7	7507600.0
2007-11-12 16:30:00	SPY	ETF	143.72	144.2	143.44	143.5	1025600.0
2007-11-12 17:00:00	SPY	ETF	143.51	143.7	143.5	143.57	1102100.0
2007-11-12 17:30:00	SPY	ETF	143.54	143.57	143.44	143.5	42400.0
2007-11-12 18:00:00	SPY	ETF	143.54	143.68	143.5	143.66	37200.0
2007-11-12 18:30:00	SPY	ETF	143.63	143.73	143.6	143.73	41400.0
2007-11-12 19:00:00	SPY	ETF	143.65	143.77	143.56	143.76	15300.0
2007-11-12 19:30:00	SPY	ETF	143.8	143.93	143.79	143.9	32500.0
2007-11-12 05:00:00	QQQ	ETF	50.11	50.12	50.11	50.12	297.0
2007-11-12 05:30:00	QQQ	ETF	49.93	49.93	49.93	49.93	1000.0
2007-11-12 06:00:00	QQQ	ETF	49.95	49.96	49.92	49.92	4400.0
2007-11-12 06:30:00	QQQ	ETF	50.05	50.18	50.04	50.15	484900.0
2007-11-12 07:00:00	QQQ	ETF	50.15	50.17	49.92	50.0	802672.0
2007-11-12 07:30:00	QQQ	ETF	50.02	50.13	49.95	49.97	792464.0
2007-11-12 08:00:00	QQQ	ETF	49.94	50.12	49.85	49.86	1293485.0
2007-11-12 08:30:00	QQQ	ETF	49.85	49.99	49.83	49.94	631231.0
2007-11-12 09:00:00	QQQ	ETF	49.96	50.02	49.9	49.93	939475.0
2007-11-12 09:30:00	QQQ	ETF	49.92	50.24	49.6	49.9985	32205503.0
2007-11-12 10:00:00	QQQ	ETF	50.0	50.0	49.6	49.8	23681629.0
2007-11-12 10:30:00	QQQ	ETF	49.8	50.09	49.69	50.02	15236180.0
2007-11-12 11:00:00	QQQ	ETF	50.02	50.24	49.94	50.15	19936385.0
2007-11-12 11:30:00	QQQ	ETF	50.15	50.17	49.8	49.8601	13780128.0
2007-11-12 12:00:00	QQQ	ETF	49.86	50.05	49.84	50.0	7664285.0
2007-11-12 12:30:00	QQQ	ETF	50.0099	50.13	49.79	49.8	7997517.0
2007-11-12 13:00:00	QQQ	ETF	49.81	49.9	49.65	49.861	12644102.0
2007-11-12 13:30:00	QQQ	ETF	49.86	49.8694	49.29	49.39	24715139.0
2007-11-12 14:00:00	QQQ	ETF	49.38	49.51	49.12	49.34	22455091.0
2007-11-12 14:30:00	QQQ	ETF	49.34	49.68	49.33	49.49	18218168.0

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

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